Bypass HTML rendering in SSRS 2000

Hi all,
I have a report (in SQL Server 2000) in a web page that is very slow when it
renders the data.
The query is not so slow to justify this problem (running it in Query
Analyzer it takes only a few seconds).
Does not have image or text field, just varchar.
I think, it's possible to "bypass" HTML rendering to reach at once Excel
rendering?
Actually the purpose of the page is to obtain a report in Excel.
Thanks a lot.
--
LuigiHTML and CSV are the fastest formats for rendering. PDF and Excel are much
slower. With RS 2000 they are an order of magnitude slower. RS 2005 sped up
significantly. RS 2008 promises additional speed improvements.
If you are using your own webpage then request the render in Excel. This is
possible with either web services or URL integration. Otherwise, if you are
using Report Manager then I suggest having a report with the parameters and
then a single textbox. The textbox just says export to Excel. Underline and
make it blue. Right mouse click, properties, Navigation, Jump to URL. The
below in Jump To URL opens up in Excel:
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=Excel','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=Excel"
Note if the data is big you are better off to use CSV ASCII format. Excel
still automatically comes up with the data.
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Luigi" <ciupazNoSpamGrazie@.inwind.it> wrote in message
news:27F7106D-8198-4D9F-B0F7-991EDB78BF71@.microsoft.com...
> Hi all,
> I have a report (in SQL Server 2000) in a web page that is very slow when
> it
> renders the data.
> The query is not so slow to justify this problem (running it in Query
> Analyzer it takes only a few seconds).
> Does not have image or text field, just varchar.
> I think, it's possible to "bypass" HTML rendering to reach at once Excel
> rendering?
> Actually the purpose of the page is to obtain a report in Excel.
> Thanks a lot.
> --
> Luigi
>|||"Bruce L-C [MVP]" wrote:
> HTML and CSV are the fastest formats for rendering. PDF and Excel are much
> slower. With RS 2000 they are an order of magnitude slower. RS 2005 sped up
> significantly. RS 2008 promises additional speed improvements.
> If you are using your own webpage then request the render in Excel. This is
> possible with either web services or URL integration. Otherwise, if you are
> using Report Manager then I suggest having a report with the parameters and
> then a single textbox. The textbox just says export to Excel. Underline and
> make it blue. Right mouse click, properties, Navigation, Jump to URL. The
> below in Jump To URL opens up in Excel:
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=Excel','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=Excel"
> Note if the data is big you are better off to use CSV ASCII format. Excel
> still automatically comes up with the data.
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>
Thank you so much Bruce, I'll test your suggestions asap.
I noticed that exporting in CSV format is a bit faster, and could be a
possible solution.
But when I obtain the CSV report, fields are separated by a comma (,), and
when I try to open this .csv in Excel, all fileds get into the first cell.
I think this is a problem due to italian settings (in english Excel this
problem does not pop up).
To solve this issues I have to replace commas with semicolons, but is a
dirty solution.
Luigi|||Hi Bruce,
I'm trying to do this:
=Globals!ReportServerUrl & "?/Report1" & "&rs:Format=Excel"
or
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?C:\projects\SNV\Software Components\Code\Bnpparibas.Sit.Reports\Report1" &
"&rs:Format=Excel','_blank'))"
but none working (no effect clicking on the hyperlink).
The report has no parameters.
What is it wrong?
Thanks.
Luigi|||A few things:
- I assume you put this in Jump to URL.
- You have to include the folder on the server the report resides
- You cannot test this from development. You have to deploy it. Jump to
report can be tested in development but not jump to URL
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Luigi" <ciupazNoSpamGrazie@.inwind.it> wrote in message
news:896D6262-E100-448A-9706-85CA10E634C0@.microsoft.com...
> Hi Bruce,
> I'm trying to do this:
> =Globals!ReportServerUrl & "?/Report1" & "&rs:Format=Excel"
> or
>
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?C:\projects\SNV\Software Components\Code\Bnpparibas.Sit.Reports\Report1"
> &
> "&rs:Format=Excel','_blank'))"
> but none working (no effect clicking on the hyperlink).
> The report has no parameters.
> What is it wrong?
> Thanks.
> Luigi|||"Bruce L-C [MVP]" wrote:
> A few things:
> - I assume you put this in Jump to URL.
> - You have to include the folder on the server the report resides
> - You cannot test this from development. You have to deploy it. Jump to
> report can be tested in development but not jump to URL
Hi Bruce,
yes, you're right.
My tests were on Visual Studio environment, and now I'm trying to test the
report on development environment.
I'll tell you.
Luigi