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 parameter([rsFieldReference] The Value expression for the...)

@.StartDate is a report parameter and CustomerNo is the field I want to render on the report,I want to combine the sql ,but it display the error message below when I preview the report.If I query in the design form and input the value of the parameter ,it run correctly .

Data sql:

declare @.sql nvarchar(4000)
declare @.sqlWhere nvarchar(4000)

set @.sql='select CustomerNo from table1 '
set @.sqlWhere=''

if @.StartDate<>''
begin
set @.sqlWhere =@.sqlWhere + ' StartDate=''' +@.StartDate + ''''
end

if ltrim(rtrim(@.sqlWhere))<>''
begin
set @.sqlWhere =' where ' + @.sqlWhere
end
set @.sql=@.sql+@.sqlWhere

exec sp_executeSQL @.sql

Error message:

[rsFieldReference] The Value expression for the textbox ‘CustomerNo’ refers to the field ‘CustomerNo’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

I'm a beginner .Help me.

|||

Please give me a answer.

|||

I wrote a procedure and the problem is resolved.

Reporting Services on the Web

Hi there

We use Reporting Services within our organisation to display real time reports on our business, we access this by typing the URL to our server,

We want to make Report manager visable over the web, how can this be done?

thanks

Tim

http://ServerName/Reports

this will open report manager in IE. If you want to open this from remote location then you have to add remote machine identity in /Home folder permisssion list on ReportServer with Content Management role.

Reporting Services Engineering Notation

In Reporting Services, is it possible to display a field in Engineering Notation or Scientific notation? I guess can do it by adding a format code, can somebody tell me the format for those notations.

Thanks

e is the code.

By the way, you can click the ellipses (...) next to format code and see all kinds of cool codes.