I have a report that ran and returns a large amount a data. When I export the report to excel it takes 3 minutes to export. The file size when I open the xls file is 24.1MB. I choose save as and give it another name ... then open the xls I just saved and the size is 9.79MB. Why is the file size different on the re-saved file than the originally exported file? This was reported by a user and I didnt believe the file size would change until I tried it myself ...sorry ... forgot to add that I am running RS2005 sp1|||If you have a lot of
string values in the report that can be represented as single byte strings,
that’s probably where Excel is making a difference. In Reporting Services we
always write strings as 2-byte Unicode, but Excel will always try to compress to
single byte when possible.
No comments:
Post a Comment