How to measure reportviewer performance

[Xena]

I have a Windows Forms application that uses SQL Server 2005 Reporting Services and displays the reports in the application using the ReportViewer control. As soon as one report is run, the entire site degrades dramatically and does not improve speed until IIS is reset. My VB.NET code is pulling two tables from a database and dumping it to a DataSet. Table one has around 4000 items, and table two has around 16000. Filling the DataSet takes about 1 second. I'm using the version of CR that comes with VB2k8 Pro by the way if that helps. Also, how does result set caching work?

[BlackSunReyes]

If you wanted to take out the expected result from the reportviewer you nee to Check if the Crystal Reports Viewer has available events such as DownloadStarted and DownloadFinished and you should explore its functionality to its extend.

[Janet J]

Use UserControl that has all necessary methods and properties to supply database path, to read report path, parameters and supply parameter values.

Also go through the Toolbars available with reportviewer

File menu >
Use the File menu to work with report files.

Open local report
Opens a report file located on your workstation.
Merge with local report
Combines one or more report files that are stored on your workstation with the report file that is currently open in the Report Viewer.
Save as local report
Saves the report on your workstation.
Export report to local HTML
Saves the report as an .html file on your workstation.
Export graph to local GIF
Saves the graph that is currently shown in the Report Viewer as a .gif file on your workstation.
Open remote report
Opens a report that is saved on the IBM Director server.
Merge with remote report
Combines one or more report files that are stored on the IBM Director server with the report file that is currently open in the Report Viewer.

To know more about the reportviewer menu check here:

[Aanand]

Can the report task be placed into a BackgroundWorker (however, I'm sure you have though of this)? At least that way you could free up the UI in the original tread. I tweaked the reports, removing handlers and fixing redundant code, but still no improvements were to be found.