Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

GrandTotals in Group footers

edited June 2006 in General
How Do I get Grand Totals of subreport items in the Group footer ?

If I only have level of Groups I can put the grandtotal in then subreport
footer.
But if I have 2 levels of groups and I want to have a grand total of all
subreports items what can I do ?

Customer Group A
Customer A1
Customer A1 - sales
Customer A1 Sales Total
Customer A2
Customer A2 - sales
Customer A2 Sales Total
Customer Group A Sales Total <- How to get that ?

Ren? SSV


--

Comments

  • edited June 2006

    I assume you mean that you have a TppVariable in the group footer of the
    main report and want to sum across serveral iterations of a subreport.

    - create a TppVariable, called varSalesTotal in the group footer of the main
    report (I assume you have a group in the main report).

    - create another TppVariable called varSubTotal in the subreport group
    footer.

    - Use the varSubTotal.OnCalc event to increment the varSubTotal and the
    varSalesTotal

    varSubTotal.Value := varSubTotal.Vale + plDetail['SomeValue];
    varSalesTotal.Value := varSalesTotal.Value + plDetail['SomeValue];





    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.