NewFocusConsult
asked on
Running Totals in Group Header
I have a debtors statement that is grouped by a field called STMTGROUP and totals transactions within that group fine. I now want to have that total appear in a Summary Grid in the Group Header but don't know how to.
ASKER
Sorry the Summary Amount is to go in the Page Header not the group header
Same problem if it is a running total.
DO you want summary of what is on the page or overall?
mlmcc
DO you want summary of what is on the page or overall?
mlmcc
ASKER
I have attached a pdf copy of the Crystal Report. You will see 2 groups the running total in each group will be a summary line in the Header section. There is a box on the right side.
debtors-statement.pdf
debtors-statement.pdf
Looks like you can use simple (rather than "running") totals. So simply insert a CrossTab.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you are using a running total to calculate it, it can't be done since the running total is calculated as the report is printed so the total isn't available until the group is complete.
Can you use a summary function on the field?
RIght click it
Click INSERT --> SUMMARY
Set it for SUM
Put it in the GROUP FOOTER
Click OK
Drag it to the group header
mlmcc