Extremely slow response on SetDataSource command

[Former Member]

Hi,

I realy hope someone can help me.

I have a report with 44 sub reports, in the report header.

The processing is very simple, and the amount of data isn't large, i get the slow loading even when there is as little as 2 rows of data in the data set.

This report used to work fine on Crystal 9 and .net 1.1

we have now upgraded to .net 3.5 and Crystal 10.0 with SP 6.0

As soon as my application hits the SetDataSource command, it takes anywhere from 1 minute to 5 minutes.

Note that in the crystal designer it displayes the report instantly.

Note that in crystal 9, it displayed the report instantly.

I'm at my wits end, and at the point of throwing the report out totally, so i would appreciate any help.

The reason for the 44 subreports, is that i have a main report, showing one total for each subreport, and when you click on it, it displays the detail.

If there is a better way of doing this, i'm also open to any suggestions

Thank you in advance and anticipation

[former_member183750 · Accepted solution]

I think here is the start of the problem:

"...we have now upgraded to .net 3.5 and Crystal 10.0 with SP 6.0"

Since you are using .NET 3.5 (e.g.; .NET 2008 ?) and CR 10 with SP 6 (CR 10.0.x), you are using an incorrect version of CR. Only CR 10.5 and CR 2008 are supported in .NET 2008.

Ludek

[Former Member]

Hi,

Thanks for the help.

I have installed a demo crystal 2008 version, and it works fine, no speed issues.

Strange, but true.

So now just to get the boss to upgrade

Edited by: Gerhard Jacobs on Jan 27, 2009 7:01 AM

[Former Member]

Please note that i have tried everything i found in this forums, all to no avail.

Also, it defnitley has to do with the sub reports, as if i remove the sub reports there is no problem anymore.