We have a requirement to display some 80,000 records in the report. The Stored procedure in the back end is displaying results in less than 2 mins..but the system hangs when we run the report.
Any work around for this strange behaviour?
When you run a report, not only do you have to collect the data, you also have to render the report, 80K records is 800 pages if you have 100 records per page.
What happens if you run the report as a scheduled report, and set the run time to the middle of the night when database and report server activity is low?
No comments:
Post a Comment