CR2010 - Performance parameter panel

[former_member755488]

Hello Sap,

Currently I'm using Crystal Reports 2010 SP1 with .Net Framework 4.0 in Visual Studio 2010.

The database is a SQL Server 2005 database with OLE DB connection.

The current problem I'm facing is the performance of the Parameter Panel when previewing a Crystal Report using the Crystal Reports components.

We are developing Crystal Reports documents using Crystal Reports 2008 SP3.6.

When we run a report in the developing environment, parameter prompting will take 10-20secs, depending on the report. This is a report based on dynamic parameters.

We first used a custom Crystal Reports Viewer, based on Crystal Reports 2008 components, here it would take the Crystal Reports Viewer 50-70 secs to show the parameter values.

We now use the Crystal Reports 2010 components, and now it takes the same report 5-8 minutes to come up with the parameter prompt. Also the Crystal Reports Viewer takes up 100% load of 1 CPU core.

What is the reason this is taking that much extra time? And how can we make this performance a little more acceptable?

The report itself isn't that fast, but we cannot change it anymore to improve performance, since most of the reports are being developed by the customer. We do have applied most report performance tips that are available on the internet.

Hope anyone can help.

With kind regards,

Pieter Jong

Crystal Advice

http://www.crystaladvice.com

[former_member755488 · Accepted solution]

Here is an overview of my performance measurement:

Report loading -> var reportDocument = new ReportDocument(); reportDocument.Load("Path");

Database -> Convert report database in code

Title modification -> Setting reportDocument.SummaryInfo settings

Parameters -> Programmatically setting of parameters

Parameter Prompt -> Time the user is interacting with the Crystal Reports Viewer, includes time to build up the parameter values

Below a overview of the performance per stage, used the System.Diagnostics.Stopwatch class.

Crystal Reports 2008 SP3.6 components / Crystal Reports 2010 SP1 components

Report loading:

6828 / 6234

Database:

318 / 253

Title modification:

50 / 59

Parameters:

115 / 99

Parameter prompt:

12332 / 226983

(time in milliseconds)

With kind regards,

Pieter Jong

Crystal Advice

http://www.crystaladvice.com

[former_member755488]

Anyone that might be able to help with this problem?

With kind regards,

Pieter Jong

Crystal Advice

http://www.crystaladvice.com

[former_member183750]

Hello Pieter

This being a report based on dynamic parameters, how many parameters are used? In CR 2008, there was a registry setting where you could specify more than the default value. I remeber reading a forum thread within the last couple of weeks that this registry setting no longer works ion CRVS2010.

But in any case, it would be great to know how may dynamic params as well as if you are using that reg key?

- Ludek

[former_member755488]

Hi Ludek,

The report consists of 10 dynamic parameters, each being a own parameter.

The report contains a list that shows the article numbers as multi-select, with 41 lists we can choose from, (aprox 2000 values) and a list of all customers as multi-select, with 28 lists we can choose from (aprox 1500 values)

The LOV has been increased to 5000, this works using registry settings. I have tried changing the values, but it didn't affect the performance.

[HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\LOV]
"MaxRowsetRecords"="5000"

The report should be optimized, only this report is being created by my client itself. In the current situation using the Crystal Reports Viewer based on CR2008, the performance is acceptable, only with the new Crystal Reports Viewer the performance has decreased by 8 times.

I would like to know what I should change in the Crystal Reports Viewer using CR2010 components or what else needs to be changed to improve the performance.

Hope anyone can help.

With kind regards,

Pieter Jong

Crystal Advice

http://www.crystaladvice.com