Post reply

Excel very sluggish after export

  • October 14, 2008 at 11:48 am

    #194571

    When I export some of my reports to Excel, Excel is very slow...like turtle slow. One report in particular has 60,000 rows and 4 levels of drill downs. Is this expected behavior? Is there anything I can do about it?

    Thanks so much for any advice.

    🙂

  • October 20, 2008 at 5:41 am

    #887060

    Exporting to Excel with more than or equal to 60000 records makes it very slow since one sheet can hold only max of 60000 records.Hence it is advisable to split the data into multiple sheets..

    For this ,just add a group to the table in the report and in expression 'Int((RowNumber(Nothing)-1)/5000)' where 5000 denotes the no : of records need to be included in one sheet .It can change based on you reqrmnt .

    Try this out.

    Reporting services will export the same format of the report to excel including driil down

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply