Hi,
I have a design question related to crystal reports.I was working on a design which had one main report and 3 subreports.The sub report linking was done between the main and each of the sub reports,but there were major performance issues as the data ran in to few thousand records and due to the sub report linking each sub report also runs that may times as the main report resulting in very poor performance beyond acceptable limits.Each of these reports run in about 5-6 minutes when run individually.But when run as a consolidated report with sub reports it takes more than an hour.
Each of the reports uses a separate stored procedure for the data.
It looks to me like this is design is not going to work in this case.I also cannot filter the data at the SP level as the users would not accept it.

Please suggest me an alternative design approach or any means by which the performance can be enhanced.

Thanks,

Saswat

Hi John,

Thanks for your reply and the valuable suggestions.
My stored proceures returns 6000 records in around 30 secs when I run them in sql tool for 1 set of parameters.But when i run the report for the same set of params it takes me around 10-15 mins with both the main report and the sub report.Also Some of the Crystal Reports native database drivers do not support the Add Command feature.Sybase Server being one of them and My data base is sybase.
Also I am doing a 5 level grouping in both the reports, but it does not seem to be helping the cause.
Should i look at other design changes like having a single stored proc instaed of invividual procs for each report.Please advice if any design change would help.

Thanks,
Saswat