Exported Excel file is too big, any idea? Thanks!

We have a report that we want to have it in Excel format, we need export it
from sql report and load in Excel and add some other elements like dropdown.
The problem is the 100 pages report is 12M when I export it from sql report.
After I load it into Excel and save it again, it is only 700k. Is there
anyway I can make the process more efficient? it is simple too
time-consuming to save a 12M file and process it.
Thanks!
--
David WENGLook here, this isn´t the binary format for excel, that the cause of being
that big.
http://groups.google.de/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f030cce8c804755/1d99a5cbbf5cff80?q=excel+%22reporting+services%22+size&rnum=5&hl=de#1d99a5cbbf5cff80
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"davidw" <davidw@.affinisys.com> schrieb im Newsbeitrag
news:eNjKukkWFHA.3240@.TK2MSFTNGP10.phx.gbl...
> We have a report that we want to have it in Excel format, we need export
> it
> from sql report and load in Excel and add some other elements like
> dropdown.
> The problem is the 100 pages report is 12M when I export it from sql
> report.
> After I load it into Excel and save it again, it is only 700k. Is there
> anyway I can make the process more efficient? it is simple too
> time-consuming to save a 12M file and process it.
>
> Thanks!
> --
> David WENG
>
>|||SP1/SP2 will use binary format instead of XML format for rendering Excel.
You might also want to consider using jump to URL and render as CSV and
ASCII (note that the export to CSV from toolbar does Unicode which Excel
does not recognize, when rendering CSV and ASCII it will be very fast). 100
pages will take quite awhile for RS to render (my guess is between 2 and 5
minutes) and will really put a load on the server. Going to CSV in ASCII
format will take seconds.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"davidw" <davidw@.affinisys.com> wrote in message
news:eNjKukkWFHA.3240@.TK2MSFTNGP10.phx.gbl...
> We have a report that we want to have it in Excel format, we need export
> it
> from sql report and load in Excel and add some other elements like
> dropdown.
> The problem is the 100 pages report is 12M when I export it from sql
> report.
> After I load it into Excel and save it again, it is only 700k. Is there
> anyway I can make the process more efficient? it is simple too
> time-consuming to save a 12M file and process it.
>
> Thanks!
> --
> David WENG
>
>