Large Excel File From SSRS Sorting

Question

A SSRS 2005 report that is run by multiple users is generating about 45,000+ records and then being exported to Excel. This is working fine, but when the users try to sort/filter the results they are seeing a huge amount of lag. At first I thought that it was just because of the large number of rows, but we found that when we stripped all of the formatting from the Excel file the report sorted and filtered quickly. Is this a common problem any of you have seen and how would you resolve it? They need the formatting to stay on the main report, so if I could somehow export without formatting that would be ideal.

Thanks!

Answer 1

There are only three settings you can set for the ReportViewer excel renderer. See Excel Device Info

Unfortunately, none of which will omit formatting in your exported report. The only thing I can suggest is that you strip out all the formatting from the RDLC report file, prior to exporting.