Hi All,

I am a newbie with crystal reports.  I have a statement report that I am trying to recreate from a legacy desktop program to use in a new web app.

I am creating Stored Procedures in SQL Server to use as data sources for my reports. 

I have created exactly the report I need using a main report and 2 sub reports.  The main report and sub reports all use a different stored procedure as a data source.

My problem is that for this report the run time in the web app is totally unacceptable for normal use. I have had some help optimizing the SP’s, but that doesn’t help much when running and printing the report. 

So my question is, is there a way to emulate 3 separate report areas in the same report each with its own group headers and footers and detail sections so that I can have the detail from sub report 1 and detail from sub report 2 on the same report?

If you would rather point me to a place where this is described, please feel free.  Thanks for any help you can give me.

Michele