Poor performance when accessing reports through URL

When viewing reports through the ReportServer application, I typically can
get response times that are between 5 and 10 seconds for my reports (in pdf
format). However, when I attempt to just view the report directly using a URL
(with the appropriate arguments supplied), the reponse time is usually 3 or 4
times worse, and it seems to eat up more resources. Is accessing reports
through a URL somehow doing something different? Anyone else experience this?
Any help would be appreciated.When you use Report Manager you are not getting the report as PDF. You are
getting them as HTML. Then through URL you can get them as PDF or HTML (your
choice). PDF and Excel formats are much much slower than HTML and are much
more resource intensive.
Try your URL as html (if you leave off the rendering format it defaults to
HTML).
You should not be seeing a difference if the format is the same with both. I
suspect that you are rendering in different formats.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"blabore" <blabore@.discussions.microsoft.com> wrote in message
news:EECE8772-5AEA-40F1-AE63-AA9A409A4646@.microsoft.com...
> When viewing reports through the ReportServer application, I typically can
> get response times that are between 5 and 10 seconds for my reports (in
> pdf
> format). However, when I attempt to just view the report directly using a
> URL
> (with the appropriate arguments supplied), the reponse time is usually 3
> or 4
> times worse, and it seems to eat up more resources. Is accessing reports
> through a URL somehow doing something different? Anyone else experience
> this?
> Any help would be appreciated.|||Bruce,
Thanks for the response. I probably wan't clear in my first post. To make
sure I was comparing apples to apples, I used the export functionality in the
report server to get a PDF. The time to complete the export was approximately
6 seconds, while when I attempted to do the same through a URL, it was over
20. To be sure that the time used to load Acrobat Reader doesn't affect
anything, I don't even have it installed, which just forces IE to download
the file. It seems odd, since the web serivce should be used no matter.
What I've found is that when I use slashes in the URL (instead of esacping
them), it significant slows things down. Is this a known issue?
"Bruce L-C [MVP]" wrote:
> When you use Report Manager you are not getting the report as PDF. You are
> getting them as HTML. Then through URL you can get them as PDF or HTML (your
> choice). PDF and Excel formats are much much slower than HTML and are much
> more resource intensive.
> Try your URL as html (if you leave off the rendering format it defaults to
> HTML).
> You should not be seeing a difference if the format is the same with both. I
> suspect that you are rendering in different formats.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "blabore" <blabore@.discussions.microsoft.com> wrote in message
> news:EECE8772-5AEA-40F1-AE63-AA9A409A4646@.microsoft.com...
> > When viewing reports through the ReportServer application, I typically can
> > get response times that are between 5 and 10 seconds for my reports (in
> > pdf
> > format). However, when I attempt to just view the report directly using a
> > URL
> > (with the appropriate arguments supplied), the reponse time is usually 3
> > or 4
> > times worse, and it seems to eat up more resources. Is accessing reports
> > through a URL somehow doing something different? Anyone else experience
> > this?
> >
> > Any help would be appreciated.
>
>|||Also, not sure if you are really comparing apples to apples. When you export
you get the report you are currently looking at. This means it uses the data
that it has already retrieved at the server. So the export would not have
the data retrieval time from whatever database you are hitting. There might
be some other differences as well.
The only other thing I can think of is authorization of the user. Could be
that this is taking some time.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"blabore" <blabore@.discussions.microsoft.com> wrote in message
news:238C6980-AD52-4CFF-BD67-84408CEE5263@.microsoft.com...
> Bruce,
> Thanks for the response. I probably wan't clear in my first post. To make
> sure I was comparing apples to apples, I used the export functionality in
> the
> report server to get a PDF. The time to complete the export was
> approximately
> 6 seconds, while when I attempted to do the same through a URL, it was
> over
> 20. To be sure that the time used to load Acrobat Reader doesn't affect
> anything, I don't even have it installed, which just forces IE to download
> the file. It seems odd, since the web serivce should be used no matter.
> What I've found is that when I use slashes in the URL (instead of esacping
> them), it significant slows things down. Is this a known issue?
> "Bruce L-C [MVP]" wrote:
>> When you use Report Manager you are not getting the report as PDF. You
>> are
>> getting them as HTML. Then through URL you can get them as PDF or HTML
>> (your
>> choice). PDF and Excel formats are much much slower than HTML and are
>> much
>> more resource intensive.
>> Try your URL as html (if you leave off the rendering format it defaults
>> to
>> HTML).
>> You should not be seeing a difference if the format is the same with
>> both. I
>> suspect that you are rendering in different formats.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "blabore" <blabore@.discussions.microsoft.com> wrote in message
>> news:EECE8772-5AEA-40F1-AE63-AA9A409A4646@.microsoft.com...
>> > When viewing reports through the ReportServer application, I typically
>> > can
>> > get response times that are between 5 and 10 seconds for my reports (in
>> > pdf
>> > format). However, when I attempt to just view the report directly using
>> > a
>> > URL
>> > (with the appropriate arguments supplied), the reponse time is usually
>> > 3
>> > or 4
>> > times worse, and it seems to eat up more resources. Is accessing
>> > reports
>> > through a URL somehow doing something different? Anyone else experience
>> > this?
>> >
>> > Any help would be appreciated.
>>

Please....tell me can it be done or not?

Can I set a URL in such a way that as soon as a report opens; it takes us to
a specified aspx page first?I'm not aware of any way to do this. What is it you are trying to
accomplish? Maybe there is some other way to do it.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RA" <rchaudhary-nospam@.storis.com> wrote in message
news:%23to4cyOzEHA.2568@.TK2MSFTNGP10.phx.gbl...
> Can I set a URL in such a way that as soon as a report opens; it takes us
to
> a specified aspx page first?
>|||If your goal is to authenticate the user, you can check out the Forms
Authentication example available from Microsoft. That auto-redirects users
who are not authenticated.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e%23MQX1OzEHA.908@.TK2MSFTNGP11.phx.gbl...
> I'm not aware of any way to do this. What is it you are trying to
> accomplish? Maybe there is some other way to do it.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RA" <rchaudhary-nospam@.storis.com> wrote in message
> news:%23to4cyOzEHA.2568@.TK2MSFTNGP10.phx.gbl...
>> Can I set a URL in such a way that as soon as a report opens; it takes us
> to
>> a specified aspx page first?
>>
>|||Just like clicking a link, we can open a report; I want to open an html or
aspx page.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e%23MQX1OzEHA.908@.TK2MSFTNGP11.phx.gbl...
> I'm not aware of any way to do this. What is it you are trying to
> accomplish? Maybe there is some other way to do it.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RA" <rchaudhary-nospam@.storis.com> wrote in message
> news:%23to4cyOzEHA.2568@.TK2MSFTNGP10.phx.gbl...
>> Can I set a URL in such a way that as soon as a report opens; it takes us
> to
>> a specified aspx page first?
>>
>|||I still don't understand what you are trying to accomplish.
If you want to integrate an existing webpage then look at URL integration.
If you want to go from some report to a web page of your choosing then you
can do a jump to URL and go anywhere you want. It does not have to be a
report.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RA" <rchaudhary-nospam@.storis.com> wrote in message
news:utTuZ3OzEHA.3548@.TK2MSFTNGP09.phx.gbl...
> Just like clicking a link, we can open a report; I want to open an html or
> aspx page.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e%23MQX1OzEHA.908@.TK2MSFTNGP11.phx.gbl...
> > I'm not aware of any way to do this. What is it you are trying to
> > accomplish? Maybe there is some other way to do it.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "RA" <rchaudhary-nospam@.storis.com> wrote in message
> > news:%23to4cyOzEHA.2568@.TK2MSFTNGP10.phx.gbl...
> >> Can I set a URL in such a way that as soon as a report opens; it takes
us
> > to
> >> a specified aspx page first?
> >>
> >>
> >
> >
>|||Try IIS "redirect" feature but don't know if it will work.
"RA" wrote:
> Can I set a URL in such a way that as soon as a report opens; it takes us to
> a specified aspx page first?
>
>|||Using Jump to URL, can a web page be opened in new window?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OgYaw7OzEHA.1400@.TK2MSFTNGP11.phx.gbl...
>I still don't understand what you are trying to accomplish.
> If you want to integrate an existing webpage then look at URL integration.
> If you want to go from some report to a web page of your choosing then you
> can do a jump to URL and go anywhere you want. It does not have to be a
> report.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RA" <rchaudhary-nospam@.storis.com> wrote in message
> news:utTuZ3OzEHA.3548@.TK2MSFTNGP09.phx.gbl...
>> Just like clicking a link, we can open a report; I want to open an html
>> or
>> aspx page.
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:e%23MQX1OzEHA.908@.TK2MSFTNGP11.phx.gbl...
>> > I'm not aware of any way to do this. What is it you are trying to
>> > accomplish? Maybe there is some other way to do it.
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "RA" <rchaudhary-nospam@.storis.com> wrote in message
>> > news:%23to4cyOzEHA.2568@.TK2MSFTNGP10.phx.gbl...
>> >> Can I set a URL in such a way that as soon as a report opens; it takes
> us
>> > to
>> >> a specified aspx page first?
>> >>
>> >>
>> >
>> >
>>
>|||A report is not a web page. RS is a web application that retrieves the
appropriate RDL from the database, renders it and returns the data. I really
don't think that would work.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mresanchez" <mresanchez@.donot-spam.com> wrote in message
news:F3CEA3E9-CDB9-4ABF-930B-BC2771B4CD07@.microsoft.com...
> Try IIS "redirect" feature but don't know if it will work.
>
> "RA" wrote:
> > Can I set a URL in such a way that as soon as a report opens; it takes
us to
> > a specified aspx page first?
> >
> >
> >|||Teo (the other MVP) just answered this in another thread. I didn't know the
answer but saw his.
= "javascript:window.open('http://www.google.com')"
Cool.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RA" <rchaudhary-nospam@.storis.com> wrote in message
news:OxqmrJPzEHA.2716@.TK2MSFTNGP14.phx.gbl...
> Using Jump to URL, can a web page be opened in new window?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OgYaw7OzEHA.1400@.TK2MSFTNGP11.phx.gbl...
>>I still don't understand what you are trying to accomplish.
>> If you want to integrate an existing webpage then look at URL
>> integration.
>> If you want to go from some report to a web page of your choosing then
>> you
>> can do a jump to URL and go anywhere you want. It does not have to be a
>> report.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RA" <rchaudhary-nospam@.storis.com> wrote in message
>> news:utTuZ3OzEHA.3548@.TK2MSFTNGP09.phx.gbl...
>> Just like clicking a link, we can open a report; I want to open an html
>> or
>> aspx page.
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:e%23MQX1OzEHA.908@.TK2MSFTNGP11.phx.gbl...
>> > I'm not aware of any way to do this. What is it you are trying to
>> > accomplish? Maybe there is some other way to do it.
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "RA" <rchaudhary-nospam@.storis.com> wrote in message
>> > news:%23to4cyOzEHA.2568@.TK2MSFTNGP10.phx.gbl...
>> >> Can I set a URL in such a way that as soon as a report opens; it
>> >> takes
>> us
>> > to
>> >> a specified aspx page first?
>> >>
>> >>
>> >
>> >
>>
>>
>|||You could always build a web application that did whatever you want and then
ran a report.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%237FEZLPzEHA.2656@.TK2MSFTNGP14.phx.gbl...
>A report is not a web page. RS is a web application that retrieves the
> appropriate RDL from the database, renders it and returns the data. I
> really
> don't think that would work.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "mresanchez" <mresanchez@.donot-spam.com> wrote in message
> news:F3CEA3E9-CDB9-4ABF-930B-BC2771B4CD07@.microsoft.com...
>> Try IIS "redirect" feature but don't know if it will work.
>>
>> "RA" wrote:
>> > Can I set a URL in such a way that as soon as a report opens; it takes
> us to
>> > a specified aspx page first?
>> >
>> >
>> >
>