Goalie35_33
November 27th, 2006, 03:37 PM
I'm running crystal 11 to generate some reports & I'm performing some pretty involved database queries to return the data to the report. After some fine tuning to my database, I've been able to execute the query in 7 seconds.
My problem however, is when I'm using the asp.net CrystalReportViewer control. Everytime I click the "Next Page" button in the report, the database re-queries and takes another 7 seconds to display. This is creating problems with our users because after a few seconds, they think something is wrong so they re-click the "Next Page" button again and again.
So my question is, is there anyway to return all of the report data at once so the report doesn't have to re-query the report every time the "Next Page" button is clicked?
Thanks in advance.
-Goalie3533
My problem however, is when I'm using the asp.net CrystalReportViewer control. Everytime I click the "Next Page" button in the report, the database re-queries and takes another 7 seconds to display. This is creating problems with our users because after a few seconds, they think something is wrong so they re-click the "Next Page" button again and again.
So my question is, is there anyway to return all of the report data at once so the report doesn't have to re-query the report every time the "Next Page" button is clicked?
Thanks in advance.
-Goalie3533