Stored Procedure Summarisation Issue

[farside11]

I am using Crystal Enterprise XI, oracle 10g and have the following issue with a very large financial reconciliation report.
The report needs to run for a date range and for a Location and then for a site or sites within that location.
I have created an SP which has the from & to dates as parameters and this returns a record set summed at each location/site level. eg.
Location Site 1 CFCash CFChq CFMoneyOrder, CFCredit, etc..
Location Site 2 CFCash CFChq CFMoney Order.......

The SP has over 500+ calculations to arrange the data into the correct payment & GL code buckets.

My problem is that in the report these location site levels now need to be aggregated to one line e.g.

Location All sites totalCFCash TotalChqAmt........

To do this in crystal would require writing approx. 1000 formulas, (due to number of classifications), and I am extremely reluctant to do this.
The parameters for the Location & Site have to be generated from Crystal as they are required to be dynamic LOVs and so I use Business Views to do this.

Is there any way I can create another record set off the SP selected by the input Location/site(s) and summed totally, ie across all location/sites.

Any help appreciated!

Regards

Leigh

 

[GJParker]

Leigh

In CR simply add summary fields to summarise at therequired level.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[lbass]

In other words, right click on your fields in the detail section->insert summary->grand total.

-LB