Search code examples
ssrs-2012

while exporting 35,000 records in excel format using SSRS , it takes too much time(20mins) to export

SSRS - Excel export time delay

I am expecting that my report to be exported within 10 seconds. I have tried adding a parent group to the Tablix by referring the link: "https://www.mssqltips.com/sqlservertip/3552/handle-excel-exceeds-maximum-65536-rows-in-ssrs-2008r2/". But it seems to be not working. Can someone please come up with a solution for my problem facing in SSRS export.

Solution

  • I hope this answers your question, here are some solutions which you can try,

    Reference: SSRS Export to Excel - Performance

    As per this blog,

    So, when the report is rendered using Excel renderer, the columns were merged to accommodate the differing column widths. I went ahead and managed to reduce the merged columns from around 5 to 1 (This would be much harder for Matrix reports). Surprisingly, this solved the issue - the size of the exported Excel file went down to < 4 MB and the report now opens in < 1 min.

    Key issues areas where you need to check,

    1. I've already added CSV file solution in the comment section.
    2. Check how many merged columns do you have in your report.
    3. Check if you have mentioned page breaks or not in your report. If not, then use it.
    4. Do you have drilldown or other links in the report? This may blow up the size of Excel.
    5. Try checking SSRS server logs they may have any specific information about this performance issue.

    Other References: Export to Excel takes long time in SSRS 2008

    Update