Reporting Services initial page load takes to long.

I have looked all over to get an answer to the following:
I have installed Reporting Services with the latest service pack. When
I or any of my customers try to initially load the default page
(http://localhost/reports/Pages/Folder.aspx) it will take 20-30
seconds. After the initial load it is fine. The next day when we try
to access it again, it takes 20-30 seconds again. I have seen two
people ask the same question on the newsgroups with no answers.
Some may feel this is not a big deal, but I am moving from one
reporting service to "Reporting Services" and the less issues my
customers have the easier it will be for me to sell this. If I could
get this corrected it would be great, but if I can not, I would at
least like a logical reason why this occurs.
Also
Is there an equivalent function in RS to Crystal's "Next" command
I am converting a report from Crystal to Reporting Services and I need
the ability to look ahead by one row (the Next command in Crystal) and
use this data from the result set to perform certain calculation. If
there is not a similar command is there a way to do this short of
creating a temp table and using a cursor?
Thanks,
TomThe initial delay occurs when ASP.Net first compiles all of the assemblies.
This occurs during the first access only. After a period of time of
inactivity the ASP.Net worker process is unloaded and the whole thing must
start over again.
For you second question I would start a new thread with a subject which
reflects the question, otherwise it might not get answered.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" <tom_barnard@.aotx.uscourts.gov> wrote in message
news:1096037678.531999.323430@.k26g2000oda.googlegroups.com...
> I have looked all over to get an answer to the following:
> I have installed Reporting Services with the latest service pack. When
> I or any of my customers try to initially load the default page
> (http://localhost/reports/Pages/Folder.aspx) it will take 20-30
> seconds. After the initial load it is fine. The next day when we try
> to access it again, it takes 20-30 seconds again. I have seen two
> people ask the same question on the newsgroups with no answers.
> Some may feel this is not a big deal, but I am moving from one
> reporting service to "Reporting Services" and the less issues my
> customers have the easier it will be for me to sell this. If I could
> get this corrected it would be great, but if I can not, I would at
> least like a logical reason why this occurs.
> Also
> Is there an equivalent function in RS to Crystal's "Next" command
> I am converting a report from Crystal to Reporting Services and I need
> the ability to look ahead by one row (the Next command in Crystal) and
> use this data from the result set to perform certain calculation. If
> there is not a similar command is there a way to do this short of
> creating a temp table and using a cursor?
>
> Thanks,
> Tom
>

Reporting Services initial application design question

I am new to Reporting Services, and I would like to serve up SQL 2005 Reporting Services reports via an ASP.NET web app (possibly using Report Viewer controls in Server mode).The web app will be running on an IIS server outside the firewall.

I would prefer to have the Reporting Services server be inaccessible outside the firewall, but it seems that the client browsers need direct URL access to the Reporting Services server.I guess this means either locating the Reporting Services server outside the firewall, or opening a hole in the firewall for access to the Reporting Services server.

Is there a Microsoft best-practice methodology/white-paper that addresses this scenario (especially as regards security concerns)?

Alternately, would it be possible, and would the same report presentation functionality be available (reports with expanding/collapsing sections, choice of export formats, etc), by calling the Reporting Services web service directly from the ASP.NET app, and manually populating the Response object?

Thanks.Any help would be appreciated.

Here is a posting that may help your scenario.

http://blogs.msdn.com/tudortr/archive/2005/11/03/488731.aspx

cheers,

Andrew

|||

Thanks for your response. I had found that link previously, but I've since found another idea that sounds promising:

Extending SQL Server Reporting Services with SQL CLR Table-Valued FunctionsExtending SQL Server Reporting Services with SQL CLR Table-Valued Functions http://msdn2.microsoft.com/en-us/library/bb293147.aspx

Reporting Services Configuration Error

I am having a problem with my SQL 2005 Report Server. I installed this
feature after the initial SQL 2005 install so I had to reapply sp2 but I can
go into the configuration manager and all looks good with no errors. When I
try and hit the \reports and \reportserver virtuals I get the following
error messages. What am I missing
-----
server/reports I get...
Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web browser
to retry your request.
Administrator Note: An error message detailing the cause of this specific
request failure can be found in the application event log of the web server.
Please review this log entry to discover what caused this error to occur.
Server/ReportServer I get...
server/ReportServer - /
----
----
Microsoft SQL Server Reporting Services Version 9.00.3042.00On Jan 27, 8:28 am, "Richard K" <rkokoski@.fox> wrote:
> I am having a problem with my SQL 2005 Report Server. I installed this
> feature after the initial SQL 2005 install so I had to reapply sp2 but I can
> go into the configuration manager and all looks good with no errors. When I
> try and hit the \reports and \reportserver virtuals I get the following
> error messages. What am I missing
> -----
> server/reports I get...
> Server Application Unavailable
> The web application you are attempting to access on this web server is
> currently unavailable. Please hit the "Refresh" button in your web browser
> to retry your request.
> Administrator Note: An error message detailing the cause of this specific
> request failure can be found in the application event log of the web server.
> Please review this log entry to discover what caused this error to occur.
> Server/ReportServer I get...
> server/ReportServer - /
> ----
> ----
> Microsoft SQL Server Reporting Services Version 9.00.3042.00
You can check a couple of things to possibly get a better error
description. You can check the Application Log via: right-click My
Computer >> select Manage >> select System Tools >> Event Viewer >>
Application. Also, you might try (if SSRS is at least communicating to
some degree) checking the Reporting Services logs normally located
here: C:\Program Files\Microsoft SQL Server\MSSQL.2 -or- MSSQL.
3\Reporting Services\LogFiles. You might want to check that the SSRS
service [SQL Server Reporting Services (MSSQLSERVER)] is running via:
right-click My Computer >> select Manage >> select Services and
Applications >> Services. Also, make sure that the ReportServer
virtual directory has been created. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant