Reporting Services Rendering is Slow

I use the web service as well as intergrated url link to display, but both
display the same characteristics. The first run is extreemly slow. We
could be talking up to 1 minute to generate a pretty basic report.
When the same report with a differnet parameter or even a different report
is run the display is immediate.
The server it sits on has not been rebooted, but if i run the same report
the next day then it runs as if its the first time its run.
Is there some kind of setting I've missed in IIS or SRS that is obviously
unloading all the compiled referneces to SRS. I understand that .net
application are slow on first execution due to compiling etc.
Can anyone help?the first time you access Reporting Service, IIS must compile the webpages.
a w3wp process starts and compile the page and then start the rendering.
after some times, the application pool is killed to released the resources
on the server.
So go in your application pool (in IIS) and change the recycle parameters.
and also you can create a scheduled task to wakeup Reporting Services.
"Namshub" <Ricchard.Pullen@.Southend.nhs.uk.RemoveMyspam> wrote in message
news:Oi#tWk8iHHA.4516@.TK2MSFTNGP03.phx.gbl...
>I use the web service as well as intergrated url link to display, but both
>display the same characteristics. The first run is extreemly slow. We
>could be talking up to 1 minute to generate a pretty basic report.
> When the same report with a differnet parameter or even a different report
> is run the display is immediate.
> The server it sits on has not been rebooted, but if i run the same report
> the next day then it runs as if its the first time its run.
> Is there some kind of setting I've missed in IIS or SRS that is obviously
> unloading all the compiled referneces to SRS. I understand that .net
> application are slow on first execution due to compiling etc.
> Can anyone help?
>
>|||maybe you should stop using MDB as a database
"Namshub" <Ricchard.Pullen@.Southend.nhs.uk.RemoveMyspam> wrote in message
news:Oi%23tWk8iHHA.4516@.TK2MSFTNGP03.phx.gbl...
> I use the web service as well as intergrated url link to display, but
both
> display the same characteristics. The first run is extreemly slow. We
> could be talking up to 1 minute to generate a pretty basic report.
> When the same report with a differnet parameter or even a different report
> is run the display is immediate.
> The server it sits on has not been rebooted, but if i run the same report
> the next day then it runs as if its the first time its run.
> Is there some kind of setting I've missed in IIS or SRS that is obviously
> unloading all the compiled referneces to SRS. I understand that .net
> application are slow on first execution due to compiling etc.
> Can anyone help?
>
>|||Snotty but not the reason. Note that it is the first time that he has
problems, not subsequent times. This is totally an IIS issue and the fact
that asp.net application (which is what RS is) gets unloaded.
Detailed instructions for solution is: Go to IIS Manager, under Applocation
Pools node, right click "DefaultAppPool" in which the Reporting Server work
process is running, select properties. On "Performace" tag, you will see,
by default, the app pool will shut down if > being idle for 20 min. You can
extend this time to 8x60min 480min, so that the app pool will not shut down
for a regular working day. However, the first report reader of the day,
will hit the delay. You may schedule a dummy report at beginning of a work
day for this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Aaron Kempf" <akempf@.dol.wa.gov> wrote in message
news:uAzPTfdjHHA.208@.TK2MSFTNGP05.phx.gbl...
> maybe you should stop using MDB as a database
>
> "Namshub" <Ricchard.Pullen@.Southend.nhs.uk.RemoveMyspam> wrote in message
> news:Oi%23tWk8iHHA.4516@.TK2MSFTNGP03.phx.gbl...
>> I use the web service as well as intergrated url link to display, but
> both
>> display the same characteristics. The first run is extreemly slow. We
>> could be talking up to 1 minute to generate a pretty basic report.
>> When the same report with a differnet parameter or even a different
>> report
>> is run the display is immediate.
>> The server it sits on has not been rebooted, but if i run the same report
>> the next day then it runs as if its the first time its run.
>> Is there some kind of setting I've missed in IIS or SRS that is obviously
>> unloading all the compiled referneces to SRS. I understand that .net
>> application are slow on first execution due to compiling etc.
>> Can anyone help?
>>
>

Reporting Services Problem

I have a URL link to a report such as in a html page. Here is a typical example

<a href = "List">http://www.myserver.com/ReportServer?%2fCustomReports%2fOrganization>List of Managers</a>

This works great and renders the report

However after I return to the calling page and perform a POST such as

<form ACTION="http://www.myserver.com/Catch.asp" METHOD="post" name="frm1" id="frm1"
<INPUT id=Var1 name = Var1 type=hidden value="valuetopost">

The variables Var1 are never passed if I do this AFTER linking to the report. It always works if I do this BEFORE calling the report. I can only get this to work again by closing out the html page and starting again

Does anyone have any ideas what is wrong?You should try posting this to SQL Server Reporting Services forum.

reporting services Permission question

I posted a report to reporting server, and link the report to asp.net
reportviewer
i link the report to the reportviewer by
Me.ReportViewer1.ServerReport.ReportServerUrl = New
Uri("http://localhost/Reportserver")
Me.ReportViewer1.serverReport.ReportPath = Server.MapPath("Report1.rdl")
however it doesn't have permission to load the report
how can i implicity to pass the user name and passwor to the reportserver
by code?Use networkcredential... look under system.net
Here is the line of code you need:
rs.Credentials = New System.Net.NetworkCredential(RSUserName, RSPassword,
RSDomain)
Where RS is the object to your reporting service web service.
RSUserName, RSPassword, and RSDomain are variables of type string.
Cheers!
=-Chris
"joe" <joe@.discussions.microsoft.com> wrote in message
news:92D8757A-6378-451C-B68B-32E2D8DC538D@.microsoft.com...
>I posted a report to reporting server, and link the report to asp.net
> reportviewer
> i link the report to the reportviewer by
> Me.ReportViewer1.ServerReport.ReportServerUrl = New
> Uri("http://localhost/Reportserver")
> Me.ReportViewer1.serverReport.ReportPath = Server.MapPath("Report1.rdl")
> however it doesn't have permission to load the report
> how can i implicity to pass the user name and passwor to the
> reportserver
> by code?|||any good links or examples, thanks you
"Chris Conner" wrote:
> Use networkcredential... look under system.net
> Here is the line of code you need:
> rs.Credentials = New System.Net.NetworkCredential(RSUserName, RSPassword,
> RSDomain)
> Where RS is the object to your reporting service web service.
> RSUserName, RSPassword, and RSDomain are variables of type string.
> Cheers!
> =-Chris
>
> "joe" <joe@.discussions.microsoft.com> wrote in message
> news:92D8757A-6378-451C-B68B-32E2D8DC538D@.microsoft.com...
> >I posted a report to reporting server, and link the report to asp.net
> > reportviewer
> > i link the report to the reportviewer by
> >
> > Me.ReportViewer1.ServerReport.ReportServerUrl = New
> > Uri("http://localhost/Reportserver")
> > Me.ReportViewer1.serverReport.ReportPath = Server.MapPath("Report1.rdl")
> >
> > however it doesn't have permission to load the report
> > how can i implicity to pass the user name and passwor to the
> > reportserver
> > by code?
>
>

Reporting services passing parameters

I have a report that is link from another report, I've created this link in the report designer by using the rightclick textbox>select properties>Navigation tab > jump to report.

Now I have passed 4 parameters over to the new report, these are hidden and shouldn't be seen by the user. There is however a fifth parameter that should be set by the user at run time, as this controls what the report shows. This works perfectly when I'm in the designer using the preview tab. However once I upload the report to the server, I get an error message saying that the fifth parameter is missing a value! Even though in report manager the fifth parameter is set to prompt User, it will not display a prompt and allow a user to input the data, it just says that the parameter is missing a value and that's as far as it gets.

I think this must have something to do with how report manager renders the parameters of a report but I can't seem to find any information on it anywhere. Can anyone help at all?

Hi James,
Two days ago I encountered the same issue with one of my reports. On the local designer studio everything worked fine and as soon as I uploaded it to Report Manager the parameter was not prompting for value but kept on complaining.
All I had to do was, save the report locally, reboot the machine and upload it again. I know its a crazy answer but it worked for me. On a hindsight, I guess it was caused by RDL file not getting updated or getting corrupt for some reason.
HTH
Uday
|||

Cheers hedgeu

I tried that though and it's still not working, i'm not sure if it's the way that i'm passing the parameters or weather it's a rendering problem all i know is i can't seem to get it to work.

James

|||

I'm not sure if this will fix your problem, but I have an idea you can try if you are still stuck.

Go to: http://localhost/Reports (keep in mind this is a different location from ReportServer)

Find the report which is accepting the parameters (ie, the one in which the user should enter a value for the parameter) and open the report.

Now, at the top of the page, click "Properties". Then select "Parameters"

Verify that your fifth parameter has a check for the prompt user option and that the hidden checkbox is not selected.

Once that is fixed, you should be good to go. Try to link to that report now.

Reporting services more navigation control

Hi there!
I have a report that has a link on another report ( something like
hyperlink to another report ). This link is configured in the Advanced
Properties under the tab Navigation. I use 'Jump to report option'.
Everything works okay, however the report to which I want to navigate is
placed in the same window, - this is not I want. Is there any way how to
show this 'linked' report in the new window automatically. (Manualy one can
choose 'Open in new window' option from the context menu).
TIA
--
Vadym StetsyakI am having the same problem and I have the reports running on a portal
(using the report manager window unfortunately). Having it launch within the
same window is not acceptable and I want to know how to have it launch in a
separate window too.
"Vadym Stetsyak" wrote:
> Hi there!
> I have a report that has a link on another report ( something like
> hyperlink to another report ). This link is configured in the Advanced
> Properties under the tab Navigation. I use 'Jump to report option'.
> Everything works okay, however the report to which I want to navigate is
> placed in the same window, - this is not I want. Is there any way how to
> show this 'linked' report in the new window automatically. (Manualy one can
> choose 'Open in new window' option from the context menu).
> TIA
> --
> Vadym Stetsyak
>
>|||I'm sure not exactly the solution you're looking for...
I've trained our users to hold [shift] down when clicking a linked report
that they want in a new window.
We use report item tooltips to help remind them.
-Nathan
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:190CE7D9-2667-4439-8F65-55C344451581@.microsoft.com...
>I am having the same problem and I have the reports running on a portal
> (using the report manager window unfortunately). Having it launch within
> the
> same window is not acceptable and I want to know how to have it launch in
> a
> separate window too.
> "Vadym Stetsyak" wrote:
>> Hi there!
>> I have a report that has a link on another report ( something like
>> hyperlink to another report ). This link is configured in the Advanced
>> Properties under the tab Navigation. I use 'Jump to report option'.
>> Everything works okay, however the report to which I want to navigate is
>> placed in the same window, - this is not I want. Is there any way how to
>> show this 'linked' report in the new window automatically. (Manualy one
>> can
>> choose 'Open in new window' option from the context menu).
>> TIA
>> --
>> Vadym Stetsyak
>>