Best Regards,
J|||What version of Reporting Services are you using on both servers? Pre SP1 of RS 2000, we rendered Excel as Excel 2003 XML spreadsheet, instead of Excel 97 binary format. It seems like an awful large difference but maybe that's the issue?
Friday, February 17, 2012
Exporting To .xls
I did a move of reporting services to another server. This was a problem before but someone else figured it out. I have a report which should be around 6MB (it was on the other server) but it exports to .xls at 67MB and will not open in Excel. When I download it as .csv it is about 3-4 MB. I seem to recall something related to headers causing the problem. But that could have been another issue. Please give me any suggestions. I have some other reports which download, slightly larger than I think they should be but they work in .xls.I'm not aware of anything that would increase the size of the report simply by moving to another server. For the difference in size between XLS and CSV, do you have a lot of images or charts in the report? They wouldn't export to CSV but will to Excel, and could be of significant size.|||No there are not any images at all. I am using the same database, same rdl file, just renamed the datasource and server name. This is very strange. It is about 1000 rows and 25 columns.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment