Reporting services 2005 extremely slow performance

I have installed Reporting 2005 as a part of SQL Server 2005 setup ( SQL
Server got upgraded from 2000 to 2005)
The general web interface is completely unresponsive!
It takes 5-10 seconds just to move between the tabs, not talking about
running reports.
I have dual Xeon 2.8Ghz machine with 3Gb of memory available - it should
respond momentarily.
Anyone with the same problem? Any ideas?
TIA.I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
a different port). SPS 2003 is very fast, but I need to wait 30s when I
click on a folder (just browse). My server is a HP 360 with 2 CPU +
4Go, I really don't understand :-(|||The first time RS starts up after a lag you will get a long pause like that.
This is an IIS thing. You can set timeout on the IIS application pools.
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
<pascal.brel@.gmail.com> wrote in message
news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
> a different port). SPS 2003 is very fast, but I need to wait 30s when I
> click on a folder (just browse). My server is a HP 360 with 2 CPU +
> 4Go, I really don't understand :-(
>|||That is not the case.
I tried everything - so far no luck.
Yes, it takes a while to load the CLR for the first time.
But the reposnse after that is still slow.
I can see a message on status bar - "downloading picture ..." of a really
small gif file for a few seconds and that is in a local mode!
Any other ideas?
Thanks.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
> The first time RS starts up after a lag you will get a long pause like
> that. This is an IIS thing. You can set timeout on the IIS application
> pools.
> 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
> <pascal.brel@.gmail.com> wrote in message
> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>|||OK, two different people on this thread. For Pascal I think it is the IIS
issue.
Oleg, is it only reports with an image? If so, where is the image stored
(database or external)? Also, initially you said just seeing the reports,
not running them. Once RS is spun up you should see the report listing
pretty instantaneously on your configuration. RS 2005 is faster than RS
2000, both for displaying report list and running the reports.
Just to make sure, this is from Report Manager, not from your own app?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
> That is not the case.
> I tried everything - so far no luck.
> Yes, it takes a while to load the CLR for the first time.
> But the reposnse after that is still slow.
> I can see a message on status bar - "downloading picture ..." of a really
> small gif file for a few seconds and that is in a local mode!
> Any other ideas?
> Thanks.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> 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
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>|||My issue is the same as Pascal's one - slow Report Manager performance.
As mentioned before - the Report manager is slow. I'm not running any
reports yet.
It is very, very slow, when moving between pages within Report Manager
interface.
Even Report Manager's own small image files are loading extremely slow,
until they are cached.
I suspect it is an IIS issue. There are a lot of other web applications
running on the same IIS server, but they are fast.
The only problem is RS 2005.
Thanks.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
> OK, two different people on this thread. For Pascal I think it is the IIS
> issue.
> Oleg, is it only reports with an image? If so, where is the image stored
> (database or external)? Also, initially you said just seeing the reports,
> not running them. Once RS is spun up you should see the report listing
> pretty instantaneously on your configuration. RS 2005 is faster than RS
> 2000, both for displaying report list and running the reports.
> Just to make sure, this is from Report Manager, not from your own app?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> 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
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>>
>|||It should be subsecond. Is this the only 2.0 framework app on your web
server?
The other possibility might be authentication. Still, you would think that
would only be right when you first connect.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:uQHu$L9OGHA.2704@.TK2MSFTNGP15.phx.gbl...
> My issue is the same as Pascal's one - slow Report Manager performance.
> As mentioned before - the Report manager is slow. I'm not running any
> reports yet.
> It is very, very slow, when moving between pages within Report Manager
> interface.
> Even Report Manager's own small image files are loading extremely slow,
> until they are cached.
> I suspect it is an IIS issue. There are a lot of other web applications
> running on the same IIS server, but they are fast.
> The only problem is RS 2005.
> Thanks.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
>> OK, two different people on this thread. For Pascal I think it is the IIS
>> issue.
>> Oleg, is it only reports with an image? If so, where is the image stored
>> (database or external)? Also, initially you said just seeing the reports,
>> not running them. Once RS is spun up you should see the report listing
>> pretty instantaneously on your configuration. RS 2005 is faster than RS
>> 2000, both for displaying report list and running the reports.
>> Just to make sure, this is from Report Manager, not from your own app?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> 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
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005
>> (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when
>> I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>>
>>
>|||Posted initially in a wrong thread.
That is the only 2.0 app in the system yet.
Uninstalled SQL Server 2005, reinstalled it completely from scratch - same
problem.
In addition to the problem description I'd like to list some verbose logs of
simply changing pages within a Report manager
w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: User
map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetProperties"
w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties('/')
w3wp!library!1!02/27/2006-11:55:26:: i INFO: Catalog SQL Server Edition =Enterprise
w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties
completed.
w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: User
map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetSystemPermissions"
w3wp!library!1!02/27/2006-11:59:34:: i INFO: Call to GetSystemPermissions
As you see:
11:55:24 - SoapAction...
11:55:26:: v VERBOSE: Call to GetProperties('/')
took two seconds to execute
11:55:26:: v VERBOSE: Call to GetProperties completed.
11:59:34:: v VERBOSE: User map'<Users>.....
8 seconds beween calls.
from another log file:
w3wp!runningrequests!1!02/27/2006-11:59:28:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListSecureMethods"
w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: User
map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetPolicies"
SoapAction ... -- took 7 seconds to execute
Seems like any SoapAction calls take a long time to execute in a local mode
on a very powerfull machine.
Question is why?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uTjABy9OGHA.1132@.TK2MSFTNGP10.phx.gbl...
> It should be subsecond. Is this the only 2.0 framework app on your web
> server?
> The other possibility might be authentication. Still, you would think that
> would only be right when you first connect.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
> news:uQHu$L9OGHA.2704@.TK2MSFTNGP15.phx.gbl...
>> My issue is the same as Pascal's one - slow Report Manager performance.
>> As mentioned before - the Report manager is slow. I'm not running any
>> reports yet.
>> It is very, very slow, when moving between pages within Report Manager
>> interface.
>> Even Report Manager's own small image files are loading extremely slow,
>> until they are cached.
>> I suspect it is an IIS issue. There are a lot of other web applications
>> running on the same IIS server, but they are fast.
>> The only problem is RS 2005.
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
>> OK, two different people on this thread. For Pascal I think it is the
>> IIS issue.
>> Oleg, is it only reports with an image? If so, where is the image stored
>> (database or external)? Also, initially you said just seeing the
>> reports, not running them. Once RS is spun up you should see the report
>> listing pretty instantaneously on your configuration. RS 2005 is faster
>> than RS 2000, both for displaying report list and running the reports.
>> Just to make sure, this is from Report Manager, not from your own app?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> 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
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005
>> (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when
>> I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>>
>>
>>
>|||Finally found a problem after looking into the System Event log. It was full
of complains about NETWORKSERVICE insufficient permissions.
Added Local Launch and Local Activation permissions of netman in DCOM config
screen to the NETWORKSERVICE account and it started to respond momentarily.
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:uc6exzkPGHA.2704@.TK2MSFTNGP15.phx.gbl...
> Posted initially in a wrong thread.
> That is the only 2.0 app in the system yet.
> Uninstalled SQL Server 2005, reinstalled it completely from scratch - same
> problem.
>
> In addition to the problem description I'd like to list some verbose logs
> of simply changing pages within a Report manager
> w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: User
> map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
> w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetProperties"
> w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties('/')
> w3wp!library!1!02/27/2006-11:55:26:: i INFO: Catalog SQL Server Edition => Enterprise
> w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties
> completed.
> w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: User
> map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
> w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetSystemPermissions"
> w3wp!library!1!02/27/2006-11:59:34:: i INFO: Call to GetSystemPermissions
> As you see:
> 11:55:24 - SoapAction...
> 11:55:26:: v VERBOSE: Call to GetProperties('/')
> took two seconds to execute
> 11:55:26:: v VERBOSE: Call to GetProperties completed.
> 11:59:34:: v VERBOSE: User map'<Users>.....
> 8 seconds beween calls.
> from another log file:
> w3wp!runningrequests!1!02/27/2006-11:59:28:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListSecureMethods"
> w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: User
> map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
> w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetPolicies"
> SoapAction ... -- took 7 seconds to execute
> Seems like any SoapAction calls take a long time to execute in a local
> mode on a very powerfull machine.
> Question is why?
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uTjABy9OGHA.1132@.TK2MSFTNGP10.phx.gbl...
>> It should be subsecond. Is this the only 2.0 framework app on your web
>> server?
>> The other possibility might be authentication. Still, you would think
>> that would only be right when you first connect.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:uQHu$L9OGHA.2704@.TK2MSFTNGP15.phx.gbl...
>> My issue is the same as Pascal's one - slow Report Manager performance.
>> As mentioned before - the Report manager is slow. I'm not running any
>> reports yet.
>> It is very, very slow, when moving between pages within Report Manager
>> interface.
>> Even Report Manager's own small image files are loading extremely slow,
>> until they are cached.
>> I suspect it is an IIS issue. There are a lot of other web applications
>> running on the same IIS server, but they are fast.
>> The only problem is RS 2005.
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
>> OK, two different people on this thread. For Pascal I think it is the
>> IIS issue.
>> Oleg, is it only reports with an image? If so, where is the image
>> stored (database or external)? Also, initially you said just seeing the
>> reports, not running them. Once RS is spun up you should see the report
>> listing pretty instantaneously on your configuration. RS 2005 is faster
>> than RS 2000, both for displaying report list and running the reports.
>> Just to make sure, this is from Report Manager, not from your own app?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause
>> like that. This is an IIS thing. You can set timeout on the IIS
>> application pools.
>> 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
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005
>>> (on
>>> a different port). SPS 2003 is very fast, but I need to wait 30s
>>> when I
>>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>>> 4Go, I really don't understand :-(
>>>
>>
>>
>>
>>
>>
>

Reporting in SQL Server

Hi,
I am developing a Intranet application using the Internet Browser as the cli
ent interface. My client needs various kinds of reports which he has to view
in the Browser. Are there any standard API's that generate the reports in H
TML format in SQL Server. A
ny help would be much appreciated. One more thing, I need to print the repor
ts to a local Dot Matrix printer. Is there any place where I can get some in
formation.
Thanks in advance
Aditya.Seen this? http://www.microsoft.com/sql/reporting/
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Aditya" <anonymous@.discussions.microsoft.com> wrote in message
news:8C056CC2-FAF8-463E-9F40-DA598685D628@.microsoft.com...
Hi,
I am developing a Intranet application using the Internet Browser as the
client interface. My client needs various kinds of reports which he has to
view in the Browser. Are there any standard API's that generate the reports
in HTML format in SQL Server. Any help would be much appreciated. One more
thing, I need to print the reports to a local Dot Matrix printer. Is there
any place where I can get some information.
Thanks in advance
Aditya.|||Hi Narayana Vyas,
Thank you for the reply. I have seen that. Presently I cannot recommend this
for the client for two reasons:
1. The reporting service is still in Beta
2. The application I am developing has been written in ASP and not .Net
I am currently writing server side components that do the complex database
interactions and the ASP that generates the dynamic HTML pages to display
the reports. I find this process too complicated and time consuming and
error prone. I was looking for any other efficient means for doing this
task.
I have another issue in this. I need to send the data (the report which the
user views in the browser) to a dot-matrix printer and it has to print in
text mode. Can you suggest any way for this?
Thanks in advance
Aditya.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OYXFlFE4DHA.2276@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Seen this? http://www.microsoft.com/sql/reporting/
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Aditya" <anonymous@.discussions.microsoft.com> wrote in message
> news:8C056CC2-FAF8-463E-9F40-DA598685D628@.microsoft.com...
> Hi,
> I am developing a Intranet application using the Internet Browser as the
> client interface. My client needs various kinds of reports which he has to
> view in the Browser. Are there any standard API's that generate the

---

reports

quote:

---

> in HTML format in SQL Server. Any help would be much appreciated. One more
> thing, I need to print the reports to a local Dot Matrix printer. Is there
> any place where I can get some information.
> Thanks in advance
> Aditya.
>

---

|||1) Its release date is less than a week away
2) Its a web service so you can use it from ASP, you don't need the app to
be written in .NET however you'd probably find it a lot easier in .NET even
if you are not that familiar with it. You can also use URL access which may
be simpler in your scenario
Also,it is highly extensible, you can write delivery extensions for
Reporting Services such as Printer Delivery extensions. It in fact includes
a Printer Delivery Extension in the devloper samples with it. I agree its
not ideal if you are not familiar with .NET but it might be well worth
getting to know it :-)
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:%2342SQNE4DHA.2404@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Hi Narayana Vyas,
> Thank you for the reply. I have seen that. Presently I cannot recommend

---

this

quote:

---

> for the client for two reasons:
> 1. The reporting service is still in Beta
> 2. The application I am developing has been written in ASP and not .Net
> I am currently writing server side components that do the complex database
> interactions and the ASP that generates the dynamic HTML pages to display
> the reports. I find this process too complicated and time consuming and
> error prone. I was looking for any other efficient means for doing this
> task.
> I have another issue in this. I need to send the data (the report which

---

the

quote:

---

> user views in the browser) to a dot-matrix printer and it has to print in
> text mode. Can you suggest any way for this?
> Thanks in advance
> Aditya.
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:OYXFlFE4DHA.2276@.TK2MSFTNGP10.phx.gbl...
to[QUOTE]
> reports
more[QUOTE]
there[QUOTE]
>

---

|||Hi Jasper Smith,
Thanks for the information. I will give it a try. Meanwhile, if you get any
other information, please pass them.
Thank you
Aditya.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:#nQ8AFF4DHA.2380@.TK2MSFTNGP09.phx.gbl...

quote:

---

> 1) Its release date is less than a week away
> 2) Its a web service so you can use it from ASP, you don't need the app to
> be written in .NET however you'd probably find it a lot easier in .NET

---

even

quote:

---

> if you are not that familiar with it. You can also use URL access which

---

may

quote:

---

> be simpler in your scenario
> Also,it is highly extensible, you can write delivery extensions for
> Reporting Services such as Printer Delivery extensions. It in fact

---

includes

quote:

---

> a Printer Delivery Extension in the devloper samples with it. I agree its
> not ideal if you are not familiar with .NET but it might be well worth
> getting to know it :-)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Aditya" <grafica@.md2.vsnl.net.in> wrote in message
> news:%2342SQNE4DHA.2404@.TK2MSFTNGP10.phx.gbl...
> this
database[QUOTE]
display[QUOTE]
> the
in[QUOTE]
the[QUOTE]
has[QUOTE]
> to
> more
> there
>

---