Query Rerun on Change of Page

[Gixonita]

Hi,

I developed about 15 different reports that are accessed through our web site, one of the reports contains a call to a stored procedure in SQL Server which is fairly complicated. If I run the report using the Crystal Reports interface it takes about 4 minutes to display the report (which is normal response time for that specific query) and I can move about it with no problem (changing pages, going from first page to last, etc). If I run the report through the web site it takes the same time to return the first page BUT if I try to go to the next page, instead of being immediate, it takes again about 4 minutes to return (any page movement will take the same amount of time), it would seem that every time I change a page the query is rerun just to get the data for the specific page I'm requesting.

I'm running Crystal Reports XI and Visual Studio 2003

I will appreciate any help provided since this is a financial query and unfortunately we have auditors with us at the moment.

Thank you

Luis Torres

 

[Madawc]

Do you have subreports?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Gixonita]

Hi Madawc,

there are no subreports, its a simple call to a stored procedure (which performs all the necessary calculations) and returns the data.

 

[Madawc]

Then sorry, I have no idea. I've never used Crystal on the Web, does anyone else know?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Gixonita]

Thanks for trying to help Madawc

 

[Gixonita]

Problem solved, to anyone interested this is what happened:

Crystal Reports XI Developer does not perform caching of the query results when working on the web, being that the reason that the query had to be re run evey time a new page was requested.

I solved this problem by generating a dataset with the results of the query which I used to feed the crystalreportviewer.

Luis Torres