Grand total for three subreports

[Timmkatt]

CR10.. I have report which shows a list of travelers and includes 2 subreports to show the total collected today, one for payment type CC and the other for cash. In the case of CC's "collected" means the card was charged and the customer signed the receipt. There is also a third subreport to show advanced cash payments collected for future travel such as in the case of someone traveling today and they want to pay cash to hold a seat for their return trip. The 2 subreports also include a Deposit field if the fare was paid at an earlier date so the total from the passenger list is not applicable. The report displays like this

9/25/08 Terminal 2
Phx Sky Harbor Run: 7:30 AM
Res# Name PAX PM Fare
123456 Test1 1 CC $33.99
789456 Test2 2 CA $67.98
894567 Test3 1 CA $33.99
Total PAX: 3

Total Payments for Run: 7:30AM
PM Total AMT Deposit Collected
CC 33.99 0.00 $33.99 (Subreport 1)
CA 101.97 33.99 $67.98 (Subreport 2)

ADVANCED CASH PAYMENTS:
Res# Travel Date Agent PM Collected
168241 10/15/08 1 CA 33.98 (Subreport 3)

So what the grand total needs to show is the sum of all three subreport collected amounts so that the report included in the envelope for the 9/25/08 7:30 am run turned into the office shows the envelope should have cash and signed CC receipts totaling $135.98. How can I add up the three subreports? Thank you

 

[dgillz]

Shared Variables in each subreport to pass the values you need total. If you need this for group totals as well as grand totals it can be a bit more complicated,but it still takes shared variables.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lbass]

What are your groups and in what sections are the subs located?

-LB