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 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 were 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]

Since you're using an Access database, create queries in Access to do all of this and then use a final Query as the datasource in Crystal.

-k