Needing more than one SQL for a main report

[bpmm]

I have a Crystal Enterprise 9 report (connecting to an access db) for a specific organization and time period. I need to calculate the percentage of critical errors found for this organization and time period. For this, I have to calculate the sum of critical errors and divide it by the total amount of critical errors in the database (there is a pre-determined list of critical errors that is not constant). In order to get the total of critical errors in the database, I created a subreport for my seperate SQL and used a shared variable to pass to my main report. That works great, the problem is I have a subreport within my main report where this calculation needs to be made. I can't have a subreport WITHIN a subreport.

Is there another way of doing this? :-(

Is it even possible to have more than one SQL statement in one report without using subreports??

I would really appreciate any feedback!

 

[synapsevampire]

Complex queries are best written on the database side, so I'd suggest creating a Query with subqueries in Access rather than using subreports in Crystal.

You'll get better speed and flexibility.

You can then base the report on the Access Query.

-k