Report with SQL Stored Procedure wont refresh

[RobHVB6Sql]

I have altered a SQL stored procedure (which grabs the info from a database). I can see a change in the records returned by running this via an SQL tool (Query Analyser).

However, when I attach this stored procedure to a report the results are not as expected.

PS I have looked at these issues:
* saved with data
* verify the database
* Also read the post "Refreshing Stored procedure data" -thread766-598906 and some others.

Any helps or hints would be greatly appreciated. This is driving me nuts. Thanks in advance.


Rob Hasard
Data Manager -Genetic Services
(VB6 /SQL 7.0)

 

[pgtek]

hi

do not save your report with data
click on database set location
and set it to the store precedure
even if it the same one
try it

cheers



pgtek

 

[synapsevampire]

Did you create a new report?

What version of Crystal?

If CR 9, then PGTEK's solution should work for you, the verify database doesn't function as expected.

If you need additional assistance, please post technical information, such as versions and what "results aren't as expected" means.

-k