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,