Export to Excel-File Size - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Export to Excel-File Size

Author

Topic

charul
Starting Member

18 Posts

Posted - 2008-12-15 : 00:38:39

When i export to excel , any report, the file size is very large.(in MB)
When i re save the file , it reduces to some KB.
Can anyone tell me how to tackle this.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-15 : 00:47:06

are you using standard export to excel functionality available in report toolbar on top? also does your report span to multiple pages?

charul
Starting Member

18 Posts

Posted - 2008-12-16 : 01:56:37

Yes he standard export. depending upon the data, the no of pages increases.
But the design is not that of multiple pages.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-16 : 02:04:11

quote:
Originally posted by charul

Yes he standard export. depending upon the data, the no of pages increases.
But the design is not that of multiple pages.

try setting interactive width property of report to -1 and then rendering report and exporting to excel.
Alternatively, instead of using standard export to excel, you can add a link on your report to get export to excel functionality and just append
&rs:Format=EXCEL&rc:OmitFormulas=true
to your report url to get full data in excel sheet

charul
Starting Member

18 Posts

Posted - 2008-12-16 : 04:19:31

in the webconfig i have this
<add key="ServerUrl" value="http://SERVER1/ReportServer$SQL2005"/>

in the vb i have this
ReportViewer1.ServerReport.ReportServerUrl = New Uri(ServerURL)
ReportViewer1.ServerReport.ReportPath = "/" & "AttendanceReportDetails"

where do i append the above?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-16 : 04:39:54

append it to value of serverurl something like
ReportViewer1.ServerReport.ReportPath = "/" & "AttendanceReportDetails&rs:Format=EXCEL&rc:OmitFormulas=true "

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources