A problem with caching Crystal Reports 10 and VS.NET

[Plato2]

I have Crystal Reports 10(Advanced version) and VS.NET 2003. I'm creating Crystal Reports with ASP.NET Crystal Report viewer(RDC). But these reports work very slow when I click a subreport or etc.
I know that Crystal Reports 10(Advanced version) has caching functionality that alows these reports to run faster when I click on an 'event' second time...
But it looks that caching is not properly working ...

Any ideas how to add "caching" functionality to Crystal Reports 10 and ASP.NET...

Thanks in advance

 

[synapsevampire]

Caching works within a specified time range if all things are the same.

It doesn't speed anything up, it simply uses a previously ran version.

I would suggest that you address your slow reports through superior design, such as eliminating subreports, and making sure that what's in the record selection formula is passed to the database for processing.

This is database dependent, but in general you'd use Database->Show SQL Query to see what's getting passed to the database.

If possible, create Views or a Stored Procedure on the database to speed things up.

-k