Refreshing Stored procedure data

[Madawc]

I use Crystal 8.5, and one of my reports uses a stored procedure that picks up data that is refreshed daily.

When I do a 'refresh' in Crystal, all it does is bring back yesterday's data. I need to go into the Crystal SQL Designer and refresh it there.

Is this the only way, or is there some clever alterntive?

Madawc Williams
East Anglia, Great Britain

 

[Naith]

Check that your report has not been saved with data, and that when you verify the database there have been no changes to the datasource.

The data must be caching from somewhere, which should not occur if you refresh ordinarily from Crystal.

Naith

 

[Madawc]

I'm not saving data with the Crystal report. I start Crystal afresh this morning, and it has the same data I was using yesterday.

I keep the query statement in the same folder, and I do save data with the query. I suppose that if I didn't, it would be OK. Thanks for the hint.

Madawc Williams
East Anglia, Great Britain

 

[synapsevampire]

Don't use the SQL Designer, and especially with a Stored Procedure, it only adds in a layer.

-k

 

[Madawc]

It's the only way I know to get a set of SQL commands from the SQL Server into Crystal. If there's another option, please tell me.

Madawc Williams
East Anglia, Great Britain

 

[synapsevampire]

I've no idea what " get a set of SQL commands from the SQL Server into Crystal" means...

Someone just refered me to this thread for another reason, sorry I didn't get back to you before, hopefully you understand it better now.

-k