Skip to Content
0
Former Member
Dec 12, 2011 at 03:26 PM

Crystal Report re-querys for data after each new page

113 Views

Hello,

I have a query that may return more rows than can fit on one report page. The query for the report may take a while to run. When I click the next page button on the report, it seems like Crystal Reports is re-running the stored procedure to get all of the data again. My current solution for this is to have Crystal Reports display all of the data at once by setting SeparatePages to false. I would rather have it only display one page at a time, but I can't do this if it is going to re-query for the data on each new page. Is there a way to get Crystal Report to temporarily store the results the first time it runs the query so it doesn't have to re-query for the data on each new page?

Thank You