Crystal Reports 8.5 - Set Location - Stored Proc - Parameters

[abcdny99]

Hi all,

I had a report in crystal reports 8.5 pointing to a stored proc with paramteres.
If I change the stored proc in report by "Set Location" it caches the parameters for that report & i get the same data for all other parameters i enter.

This only happens if i run the report from VC++ 6.0.
From crystal reports i get fresh data for every parameter change.

Thanks in Advance,
Neel

 

[vidru]

I've seen this happen before. Try running a Verify Database on the report. When prompted for the Stored Procedure parameters, check the Set to NULL value box for each parameter, and click OK. Also, make sure that 'Save Data with Report' under the File menu isn't checked.

-dave