SQL 2000 Stored Procs & CR9

[misuser]

I havent used SQL 2000 Stored procs much yet with Crystal

I think my question is quite basic(!)

I have connected CR9 to an SQL Server 2000 DB stored procedure as the data source. this works fine - I get the data I need. When CR9 connects to the Stored Proc tomorrow will the data be the same or does it hit the data base everytime it connects to the stored proc. Alternatively do I need to schedule the stored proc so the data it returns changes each day?

any help very welcome, thanks!

 

[vidru]

Stored procedures don't cache their results. When you refresh the report, the procedure will refresh the data.

-dave