reduce rendering time in RS2005

We have a reporting system where the default rendering format is HTML.
HOwever, in some cases user may export the data into Excel aftergenerating
the report in HTML. Howveer, this export is taking too much time. eg 5500
row report in HTML takes around 8 minutes to export into excel. Is there a
workaround for this? Please note that default rendering has to be in HTML
only.
Also another feature noticed is that in RS 2005, the report server execution
log seems to be logging seperate entries for export feature as well. This
was not happening in RS2000. Is this a new feature in RS2005 or is the
underlying SP for the new report being called again when the export to excel
happens?
Any help would be appreciatedOn Feb 19, 11:32 pm, SK <S...@.discussions.microsoft.com> wrote:
> We have a reporting system where the default rendering format is HTML.
> HOwever, in some cases user may export the data into Excel aftergenerating
> the report in HTML. Howveer, this export is taking too much time. eg 5500
> row report in HTML takes around 8 minutes to export into excel. Is there a
> workaround for this? Please note that default rendering has to be in HTML
> only.
> Also another feature noticed is that in RS 2005, the report server execution
> log seems to be logging seperate entries for export feature as well. This
> was not happening in RS2000. Is this a new feature in RS2005 or is the
> underlying SP for the new report being called again when the export to excel
> happens?
> Any help would be appreciated
Have you tried exporting to a CSV file?|||This seems excessive amount of time for 5500 rows. I do much more than that
all the time. Of course, complexity matters. Also, any images in the report?
As suggested see how long it takes to export CSV. CSV takes the same amount
of time as HTML.
Also, if you do this you will want to change the CSV to use ASCII instead of
unicode. Excel puts unicode into a single column. To have RS export CSV in
ASCII format you have to make a change to a config file.
You only need to change in one place, rsreportserver.config. Reboot after
the change. The below shows commenting out the existing entry and putting in
the needed change to have CSV export as ASCII
<!--
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
-->
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SK" <SK@.discussions.microsoft.com> wrote in message
news:D94C7011-C90D-46F7-AA75-E33CC8BEFF1A@.microsoft.com...
> We have a reporting system where the default rendering format is HTML.
> HOwever, in some cases user may export the data into Excel aftergenerating
> the report in HTML. Howveer, this export is taking too much time. eg
> 5500
> row report in HTML takes around 8 minutes to export into excel. Is there
> a
> workaround for this? Please note that default rendering has to be in HTML
> only.
> Also another feature noticed is that in RS 2005, the report server
> execution
> log seems to be logging seperate entries for export feature as well. This
> was not happening in RS2000. Is this a new feature in RS2005 or is the
> underlying SP for the new report being called again when the export to
> excel
> happens?
> Any help would be appreciated