I have a report (stored procedure) that I have set up in SQL 2005
Reporting Services. In a web app, I put a Reportviewer control on the
page, and call the report. After a lot of trial & error, it appears to
work.
Sort of.
What happens is when I open it on that tab (I am using AJAX Tab panels,
which had been working fine without this behavior prior to finally
getting the reportviewer working), and the report displays, the "e" on
Internet explorer at the top of the tab now flickers, like the page is
reloading. It also runs the CPU up to 100% on the computer and although
I can go from tab to tab in it (I am using AJAX tab panels in the page),
it will take like up to a minute to go to the next tab. I'm not doing
anything really data-intensive on those tabs, and they had been
functioning fine prior to putting in the report viewer (i.e. they
weren't flickering & clocking the CPU).
I eventually have to kill the page to do anything, because it has the
system up to 100%.
Any idea why reportviewer might make this act this way?
Thanks for the help,
7  1881 
How much data are you churning in RS? The way to tell is look at how much
data is actaully returned from the sproc.
As much as possible, try to filter down your data and do calcs in the sproc,
not in RS. If you return large data sets to RS, you will churn the machine.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)
************************************************
Think outside the box!
************************************************
"Blasting Cap" <go****@christian.netwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>I have a report (stored procedure) that I have set up in SQL 2005 Reporting
Services. In a web app, I put a Reportviewer control on the page, and call
the report. After a lot of trial & error, it appears to work.
Sort of.
What happens is when I open it on that tab (I am using AJAX Tab panels,
which had been working fine without this behavior prior to finally getting
the reportviewer working), and the report displays, the "e" on Internet
explorer at the top of the tab now flickers, like the page is reloading.
It also runs the CPU up to 100% on the computer and although I can go from
tab to tab in it (I am using AJAX tab panels in the page), it will take
like up to a minute to go to the next tab. I'm not doing anything really
data-intensive on those tabs, and they had been functioning fine prior to
putting in the report viewer (i.e. they weren't flickering & clocking the
CPU).
I eventually have to kill the page to do anything, because it has the
system up to 100%.
Any idea why reportviewer might make this act this way?
Thanks for the help,
That's just it - the data isn't that much.
I'm calling a stored procedure with 5 parameters, and it returns 1588
rows in Query Analyzer, and runs in 5 seconds there. The only
difference in QA and the Reportviewer is that I am subtotaling & grand
totaling 3 columns.
If I try to run this from within the ReportViewer, when launching that
web page, it will run the CPU up to 100% until I kill it. Pages are
extremely sluggish, and it'll take a minute or two to just go between
tabs on those 3 pages. I'm doing a Gridview on one tab, that returns
about 50 records, and a dropdown box on the second tab that returns
about 25 records, and then this one that I'm doing in the Reportviewer.
If I take out the reportviewer, the other two pages work as they should,
in next to no time at all.
Once I add back the reportviewer, the "e" on the Internet Explorer tab
flickers and I can watch the CPU usage on the computer go to 100% and
stay there until I kill the procedure. I can close it out using the X
on internet explorer, but it takes several minutes for the web browser
to detect that I've killed the window.
This is behavior beyond strange.
BC
Cowboy (Gregory A. Beamer) wrote:
How much data are you churning in RS? The way to tell is look at how much
data is actaully returned from the sproc.
As much as possible, try to filter down your data and do calcs in the sproc,
not in RS. If you return large data sets to RS, you will churn the machine.
Try returning the aggregates from the stored procedure and see how that
changes things. It could be that your total calculations are causing issue.
I will have to mull over other possibilities.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)
************************************************
Think outside the box!
************************************************
"Blasting Cap" <go****@christian.netwrote in message
news:ec**************@TK2MSFTNGP03.phx.gbl...
That's just it - the data isn't that much.
I'm calling a stored procedure with 5 parameters, and it returns 1588 rows
in Query Analyzer, and runs in 5 seconds there. The only difference in QA
and the Reportviewer is that I am subtotaling & grand totaling 3 columns.
If I try to run this from within the ReportViewer, when launching that web
page, it will run the CPU up to 100% until I kill it. Pages are extremely
sluggish, and it'll take a minute or two to just go between tabs on those
3 pages. I'm doing a Gridview on one tab, that returns about 50 records,
and a dropdown box on the second tab that returns about 25 records, and
then this one that I'm doing in the Reportviewer.
If I take out the reportviewer, the other two pages work as they should,
in next to no time at all.
Once I add back the reportviewer, the "e" on the Internet Explorer tab
flickers and I can watch the CPU usage on the computer go to 100% and stay
there until I kill the procedure. I can close it out using the X on
internet explorer, but it takes several minutes for the web browser to
detect that I've killed the window.
This is behavior beyond strange.
BC
Cowboy (Gregory A. Beamer) wrote:
>How much data are you churning in RS? The way to tell is look at how much
data is actaully returned from the sproc.
As much as possible, try to filter down your data and do calcs in the
sproc, not in RS. If you return large data sets to RS, you will churn the
machine.
What happens when you run the report from the web interface using Report
Manager. This will tell you if it is a report issue or an integration issue
with ReportViewer. My guess is that you are telling reportviewer over and
over again to get the report.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blasting Cap" <go****@christian.netwrote in message
news:ec**************@TK2MSFTNGP03.phx.gbl...
That's just it - the data isn't that much.
I'm calling a stored procedure with 5 parameters, and it returns 1588 rows
in Query Analyzer, and runs in 5 seconds there. The only difference in QA
and the Reportviewer is that I am subtotaling & grand totaling 3 columns.
If I try to run this from within the ReportViewer, when launching that web
page, it will run the CPU up to 100% until I kill it. Pages are extremely
sluggish, and it'll take a minute or two to just go between tabs on those
3 pages. I'm doing a Gridview on one tab, that returns about 50 records,
and a dropdown box on the second tab that returns about 25 records, and
then this one that I'm doing in the Reportviewer.
If I take out the reportviewer, the other two pages work as they should,
in next to no time at all.
Once I add back the reportviewer, the "e" on the Internet Explorer tab
flickers and I can watch the CPU usage on the computer go to 100% and stay
there until I kill the procedure. I can close it out using the X on
internet explorer, but it takes several minutes for the web browser to
detect that I've killed the window.
This is behavior beyond strange.
BC
Cowboy (Gregory A. Beamer) wrote:
>How much data are you churning in RS? The way to tell is look at how much
data is actaully returned from the sproc.
As much as possible, try to filter down your data and do calcs in the
sproc, not in RS. If you return large data sets to RS, you will churn the
machine.
Just for giggles, I did another report, basically taking a product
listing, that would return about 100 records, that had some numeric
fields on it, but I didn't do any summing or totalling.
This report performs the same way when I call it from the reportviewer.
If I go to the website, http://mycomputer/reports$sql2005, and run it,
it takes about 5 seconds to display & you don't get the "flickering" of
the "e" on Internet Explorer like you do when I try to run the same
report from within the report viewer.
How am I telling the reportviewer over & over again to get the report?
The fact that I have no totaling in the report tells me that it's not
the returning of the data that is the problem.
The code that calls the report:
<cc1:TabPanel ID="TabPanel3" runat="server" HeaderText="TabPanel3">
<ContentTemplate>
<rsweb:reportviewer id="ReportViewer1"
runat="server" font-names="Verdana" font-size="8pt"
height="90%" width="90%"
ProcessingMode="Remote">
<ServerReport ReportServerUrl="http://mycomputer/ReportServer$SQL2005/"
ReportPath="/BA10listing"></ServerReport>
</rsweb:reportviewer>
</ContentTemplate>
</cc1:TabPanel>
BC
Bruce L-C [MVP] wrote:
What happens when you run the report from the web interface using Report
Manager. This will tell you if it is a report issue or an integration issue
with ReportViewer. My guess is that you are telling reportviewer over and
over again to get the report.
I have only used the winform version of the reportviewer control (I assume
you are using the reportviewer control that ships with VS 2005). Somewhere
you have to be responding to an event where you tell the control what report
to render. If you do this over and over again you could be causing it to
thrash.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blasting Cap" <go****@christian.netwrote in message
news:OD**************@TK2MSFTNGP04.phx.gbl...
Just for giggles, I did another report, basically taking a product
listing, that would return about 100 records, that had some numeric fields
on it, but I didn't do any summing or totalling.
This report performs the same way when I call it from the reportviewer.
If I go to the website, http://mycomputer/reports$sql2005, and run it, it
takes about 5 seconds to display & you don't get the "flickering" of the
"e" on Internet Explorer like you do when I try to run the same report
from within the report viewer.
How am I telling the reportviewer over & over again to get the report?
The fact that I have no totaling in the report tells me that it's not the
returning of the data that is the problem.
The code that calls the report:
<cc1:TabPanel ID="TabPanel3" runat="server" HeaderText="TabPanel3">
<ContentTemplate>
<rsweb:reportviewer id="ReportViewer1"
runat="server" font-names="Verdana" font-size="8pt"
height="90%" width="90%"
ProcessingMode="Remote">
<ServerReport ReportServerUrl="http://mycomputer/ReportServer$SQL2005/"
ReportPath="/BA10listing"></ServerReport>
</rsweb:reportviewer>
</ContentTemplate>
</cc1:TabPanel>
BC
Bruce L-C [MVP] wrote:
>What happens when you run the report from the web interface using Report
Manager. This will tell you if it is a report issue or an integration
issue with ReportViewer. My guess is that you are telling reportviewer
over and over again to get the report.
Try the reportviewer control on a simple web page and see if the same thing
happens. I.e. no tabs, just a single simple web page.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blasting Cap" <go****@christian.netwrote in message
news:OD**************@TK2MSFTNGP04.phx.gbl...
Just for giggles, I did another report, basically taking a product
listing, that would return about 100 records, that had some numeric fields
on it, but I didn't do any summing or totalling.
This report performs the same way when I call it from the reportviewer.
If I go to the website, http://mycomputer/reports$sql2005, and run it, it
takes about 5 seconds to display & you don't get the "flickering" of the
"e" on Internet Explorer like you do when I try to run the same report
from within the report viewer.
How am I telling the reportviewer over & over again to get the report?
The fact that I have no totaling in the report tells me that it's not the
returning of the data that is the problem.
The code that calls the report:
<cc1:TabPanel ID="TabPanel3" runat="server" HeaderText="TabPanel3">
<ContentTemplate>
<rsweb:reportviewer id="ReportViewer1"
runat="server" font-names="Verdana" font-size="8pt"
height="90%" width="90%"
ProcessingMode="Remote">
<ServerReport ReportServerUrl="http://mycomputer/ReportServer$SQL2005/"
ReportPath="/BA10listing"></ServerReport>
</rsweb:reportviewer>
</ContentTemplate>
</cc1:TabPanel>
BC
Bruce L-C [MVP] wrote:
>What happens when you run the report from the web interface using Report
Manager. This will tell you if it is a report issue or an integration
issue with ReportViewer. My guess is that you are telling reportviewer
over and over again to get the report.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Muumac |
last post by:
I have problem with large textfiles! When I load over 4MB xml and then
try to preg_match something in this I get always FALSE!
I have <File>....</File> tags in XML. Between tags is files contents...
|
by: lebo |
last post by:
I'm experimenting with using Python as a very low resource usage
systems management agent. Currently the best I'm getting is about a
2.4MByte base usage (python interp only) and with application,...
|
by: E. Robert Tisdale |
last post by:
Eats, Shoots & Leaves
http://www.eatsshootsandleaves.com/
I believe that
C programmers should follow the *normal" rules of punctuation --
especially in their C programs.
|
by: Merrill & Michele |
last post by:
Section 2.3 of K&R enumerates the complete set of escape sequences.
Q1) Is it possible to ask the following question without getting into
implementation/platform talk?
Q2) What on earth is...
|
by: Daniel Vallstrom |
last post by:
I'm having problems with inconsistent floating point behavior
resulting in e.g.
assert( x > 0.0 && putchar('\n') && x == 0.0 );
holding. (Actually, my problem is the dual one where I get...
| | |
by: Paminu |
last post by:
In math this expression:
(a < b) && (b < c)
would be described as:
a < b < c
But why is it that in C these two expressions evaluate to something
different for the same values of a, b and...
|
by: gundam.f0rtre55 |
last post by:
Hi everybody,
for a new release of our J2EE Webapplication, our customer wish to
allow the usage of bookmarklets. The application must be able to
register URLs with several protocol types, one of...
|
by: Smokey Grindel |
last post by:
I am writing an application on a 64bit workstation (XP Pro x64) and I am
using reporting services which is installed as a 64bit sql server instance,
but my project needs to reference the .NET...
|
by: Alf P. Steinbach |
last post by:
I once suggested in that SomeOne Else(TM) should propose
a string value class that accepted literals and char pointers and so on,
with possible custom deleter, and in case of literal strings just...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |
