report pack for iis - report generation taking long?

I've got this installed and the sample database was working fine. I then
imported about a weeks worth from two iis servers (grew the DB to about 5
GB) and now pulling up any of the default 12 reports takes at least 30
minutes to an hour or longer. Is this normal? The SQL server is a dual
xeon, 2 GB of RAM, 3 disk (15k rpm) raid 5 with SQL 2000 SP3 and Reporting
Services SP2.Try to do a select of the same data and see how long it takes...RS will be
slower than that of course - but will not be faster than your select when it
queries the data..
Ensure you have properly indexed tables.
You may also wish to run the query on a schedule and deliver it from cache -
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Joe" <joe@.do.not.email.me> wrote in message
news:%23%234FpU4qFHA.248@.TK2MSFTNGP14.phx.gbl...
> I've got this installed and the sample database was working fine. I then
> imported about a weeks worth from two iis servers (grew the DB to about 5
> GB) and now pulling up any of the default 12 reports takes at least 30
> minutes to an hour or longer. Is this normal? The SQL server is a dual
> xeon, 2 GB of RAM, 3 disk (15k rpm) raid 5 with SQL 2000 SP3 and Reporting
> Services SP2.
>

Report generation time between users and admin

Hi,

When we generate a report with an account that is in the admin group it takes 2-3 seconds but when we do it with another user it takes over 2 minutes... any reason for this?

(The "Report is being generated" thing, by the way)

Not sure if my question is clear, I've been looking and searching for the past 2 hours but can't find anything remotly close to that problem... any help would be appreaciated!

Thanks

Wacky guess:

Are temp files for the two accounts going to different places, for example there is a "home" drive for normal users that is not local?

>L<

Report generation is consuming 100% of CPU client side.

Hi,

I have a problem while rendering a report which returns around 5000 rows. At first the server is busy to process the request, when the server is done the rendering client side takes 100% of CPU and never displays the result ("IE is not responding"). It seems that the ReportViewer has trouble to handle the server response.

Do you have any idea why ?

Sbastien.

It appeared that the problem is a paging issue. The report contains groups and by default the top level is collapsed, when we try to expand a level that contains many rows thoses rows are all displayed on a single page. That's why IE is consuming 100% of the CPU to display all the rows.

How can I change that the paging is working for the sub groups displayed ?

|||

I found the answer in BOL:

"The HTML and Excel rendering extensions are not oriented to physical pages. Furthermore, the HTML rendering extension is interactive, meaning that user actions in a report can trigger additional processing that causes a report to expand horizontally or vertically to accommodate additional content. You cannot precisely control how reports viewed through these rendering extensions will paginate if the report contains interactive features."

Report generation is consuming 100% of CPU client side.

Hi,

I have a problem while rendering a report which returns around 5000 rows. At first the server is busy to process the request, when the server is done the rendering client side takes 100% of CPU and never displays the result ("IE is not responding"). It seems that the ReportViewer has trouble to handle the server response.

Do you have any idea why ?

Sbastien.

It appeared that the problem is a paging issue. The report contains groups and by default the top level is collapsed, when we try to expand a level that contains many rows thoses rows are all displayed on a single page. That's why IE is consuming 100% of the CPU to display all the rows.

How can I change that the paging is working for the sub groups displayed ?

|||

I found the answer in BOL:

"The HTML and Excel rendering extensions are not oriented to physical pages. Furthermore, the HTML rendering extension is interactive, meaning that user actions in a report can trigger additional processing that causes a report to expand horizontally or vertically to accommodate additional content. You cannot precisely control how reports viewed through these rendering extensions will paginate if the report contains interactive features."

Report Generation Image

Is there any way to change the image "Report is being generated" to something else or at least change the location of it. I have a report that is very long and our users have to scroll down to see that. They think the report is frozen when in all reality it is still generating. It is postioning in the center of the page and I want it to position at the top.This behavior could happen on very old CTP releases. Are you seeing this on SQL Server 2005 RTM?

-- Robert|||Yes this is on the RTM version. I have the report viewer within a sharepoint site. The height of the sharepoint site is large in order to view the report without having a scroll bar for the report and one for sharepoint. So if you make the height of the sharepoint size large then the scroll bar for the report viewer disappears. However, this makes the "Report is being generated" message go out of sight.|||

I have the same problem using VS2005 Pro [8.0.50727.42 (RTM.050727-4200)] and SQL Server 2005 Std [9.0.1399]. My report viewer control is set to 1000px height to avoid a scroll bar from the viewer control and a 2nd scrollbar from IE

Dirk

|||Any chance of having this available in the future? Our clients would love it.

Report Generation Image

Is there any way to change the image "Report is being generated" to something else or at least change the location of it. I have a report that is very long and our users have to scroll down to see that. They think the report is frozen when in all reality it is still generating. It is postioning in the center of the page and I want it to position at the top.This behavior could happen on very old CTP releases. Are you seeing this on SQL Server 2005 RTM?

-- Robert|||Yes this is on the RTM version. I have the report viewer within a sharepoint site. The height of the sharepoint site is large in order to view the report without having a scroll bar for the report and one for sharepoint. So if you make the height of the sharepoint size large then the scroll bar for the report viewer disappears. However, this makes the "Report is being generated" message go out of sight.|||

I have the same problem using VS2005 Pro [8.0.50727.42 (RTM.050727-4200)] and SQL Server 2005 Std [9.0.1399]. My report viewer control is set to 1000px height to avoid a scroll bar from the viewer control and a 2nd scrollbar from IE

Dirk

|||Any chance of having this available in the future? Our clients would love it.

Report Generation Image

Is there any way to change the image "Report is being generated" to something else or at least change the location of it. I have a report that is very long and our users have to scroll down to see that. They think the report is frozen when in all reality it is still generating. It is postioning in the center of the page and I want it to position at the top.This behavior could happen on very old CTP releases. Are you seeing this on SQL Server 2005 RTM?

-- Robert|||Yes this is on the RTM version. I have the report viewer within a sharepoint site. The height of the sharepoint site is large in order to view the report without having a scroll bar for the report and one for sharepoint. So if you make the height of the sharepoint size large then the scroll bar for the report viewer disappears. However, this makes the "Report is being generated" message go out of sight.|||

I have the same problem using VS2005 Pro [8.0.50727.42 (RTM.050727-4200)] and SQL Server 2005 Std [9.0.1399]. My report viewer control is set to 1000px height to avoid a scroll bar from the viewer control and a 2nd scrollbar from IE

Dirk

|||Any chance of having this available in the future? Our clients would love it.

Report Generation Chaining

Hi
Is there an easey way to set up report generation chaining (i.e.
automatically start a second report once the first completes)?
Many thanks,
Dave HughesIn a simila vein, is there a way to ensure reports that share a schedule are
processed sequentially (in the belief that the server will be happier
processing one at at time rather than 20 at the same scheduled start time)?
Ta
Dave Hughes
"David Hughes" <spamfree@.freespam.com> wrote in message
news:uCUQ%23GbxEHA.3844@.TK2MSFTNGP12.phx.gbl...
> Hi
> Is there an easey way to set up report generation chaining (i.e.
> automatically start a second report once the first completes)?
> Many thanks,
> Dave Hughes
>