Hello I am very new at Crystal Reports and i have written a main report with 2 subreports, which each have totals.  How do I get grand totals of my totals on subreports to my Main report ?   I need really detailed explanation of how to do this.    (my main report shows all our sales reps, one of the subreports shows invoice activity for them, with a total at each group level - grouped by invoice number...and the other subreport shows all open orders for them - grouped by order number.) My totals are correct in each subreport, but I need to figure out a way to get grand totals for the end of my MAIN report. one total of all invoice activity and one total of all open orders. Please help!  i'm really lost...thanks!   I have read something about variables, but do not understand them at all.

Edited by Kitty1 - 04 Jan 2011 at 12:00pm

Hi Lockwelle and thanks for your reply, however I'm still lost!  (sorry) 

I understand about creating a formula and placing it in the report footer, which I did.  I am coming up with a total on my main report, but it is a zero total...  I must have done something wrong.

Hi Lockwelle,

Thanks again for your reply.  What i'm looking to get is a GRAND TOTAL of all the subtotals at each group section.  I found out the variable is working, but I'm not able to add them all to get a grand total.   The way the report is, it lists the salesman on the main report, then goes to subreport #1 to pick up their invoice activity, then goes to subreport #2 to pick up open orders for that rep, then goes back to main report and on to the next salesman and starts all over again.  So I'm losing my values as the salesman changes, I just can't figure out a way to get a running total of all the subtotals. 

Hi Lockwelle