Hi,
I have a report returning about 50000 rows, when i export this into excel it takes a few minutes and the file size is about 13MB, When i try to open up a 13mb file it is so slow...it is better for me to execute the dataset in SQL analyser and copy the results directly into excel whereby the file is 8mb and opens up also instantly...
My exported version is just data and no graphics however the page appears to be ''white'' although i set the fill in excel to transparent...maybe this is making the file hard to open...
Anybody have problems with exporting to excel and actually able to use it without running into long delays due to the file size...what can i do to fix this
thanks
Wait for SQL Server 2008 apparently.
One of the biggest resource hogs is output to Excel. One of the whitepapers suggests 2x-3x Ram (ratio to dataset size) is required for Excel gen.
Otherwise, set it on a schedule and email the report when it is done.
No comments:
Post a Comment