summary field / groups

[shelbygn]

Crystal Reports 9
Oracle Database

having problems showing group footer #2's summary
fields in group footer #1 section.

the report displays amounts in the details section.
the report is group by eng, cli, section, and invoice.
new page after each invoice.

example:
inv 1
CLI ENG AMOUNT
section A
cli 1
eng 1 5
3
2
eng 1 tl 10
eng 2 4
3
eng 2 tl 7
cli 1 tl 17
cli 2
eng 3 5
eng 3 tl 5
cli 2 tl 5
section A tl 22

section B
cli 1
eng 1 5
3
2
eng 1 tl 10
cli 1 tl 10
section B tl 10


Section A Total 22 {<= problem is here }
Section B Total 10 {<= problem is here }

inv 2 {etc}....


I am having problems getting the Section Totals in the
Invoice group footer. The summary fields for the
other group footers are working correctly.
Not sure how to get the Section group footer summary
fields in the Invoice group footer.

Thank you.

 

[lbass]

The easiest way might be to insert a crosstab in the invoice group footer that uses Section as a row and amount as the summary field. Otherwise, you could use running totals. Using the running total editor, you would select {table.amt}, sum, evaluate based on a formula:

{table.section} = "A"

Reset on change of group (Invoice).

Repeat for the Section B running total, changing the evaluation formula to use "B".

Then place the running totals in the invoice group footer.

-LB

 

[synapsevampire]

You might use a cross-tab to do this more simply. Drop the Section in to the rows and the Amount in the details and place it in the Section group footer.

Or note that if you hide everything except for that group footer where the section totals are coming, you have your requirements met.

What you're asking for is the report to do the totals seperately at the grouping level, and then again summarize them at the outer group level.

-k