Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
 Posted - 2011-11-11 : 02:31:39
|
| Guys,I have an SSRS report and the result was save as in Excel File.It composed of 10 columns with 5,800 records.the problem was when they open the excel file it takes time and when they use the filter it has waiting time to filter the records. even moving and scrolling the records has also delays. I already remove the fill color of the reports.may i know what is the cause of delay to open, filtering and scrolling of records. also how to reduce the size of the reports(output)? is there any configuration to reduce the size?thank you in advance.JOV |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-11 : 03:31:59
|
quote:
Originally posted by Villanuev
Guys,I have an SSRS report and the result was save as in Excel File.It composed of 10 columns with 5,800 records.the problem was when they open the excel file it takes time and when they use the filter it has waiting time to filter the records. even moving and scrolling the records has also delays. I already remove the fill color of the reports.may i know what is the cause of delay to open, filtering and scrolling of records. also how to reduce the size of the reports(output)? is there any configuration to reduce the size?thank you in advance.JOV
Are you using too many expressions or images in report?That might also take considerable amount of report render time. ALso check if you've some unwanted datasets included in it, if so remove themFOr reducing size of report go to report properties and you've width and height settings. change it accordingly------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
How to reduce the size of rdl SSRS 2008