| Summarising Group totals in separate table [message #1793449] |
Wed, 08 August 2018 13:52 |
 Steve Brown
Messages: 4
Registered: March 2013 |
Junior Member |
|
|
Hi all,
Long time since I have needed to post on here I hope you can help me!
I have a report which has 2 groups, one - ProductGroup - is "inside" the other one - ABCClass.
This is the layout and example of my report:
Group: ABCClass: A
Group: ProductGroup 1
product1 50
product2 58
product3 23
Group: ProductGroup 1 total: 131
Group: ProductGroup 2
product4 49
product5 12
product6 19
Group: ProductGroup 2 total: 80
Group: ABCClass: A total: 211
Group: ABCClass: B
Group: ProductGroup 3
product7 40
product8 20
product9 10
Group: ProductGroup 3 total: 70
Group: ProductGroup 4
product10 5
product11 7
product12 9
Group: ProductGroup 4 total: 21
Group: ABCClass: B total: 91
...etc...
This repeats for as many ProductGroups and ABCClass records that are found.
At the very end of the report, I have this table/grid:
ABCClass: A 211
ABCClass: B 91
ABCClass: C 0
...etc
There are always a set number of ABCClass heading here. I need the totals for each specific ABCClass group next to it's title, and where an ABCClass is not in the report, I need a zero instead.
How do I achieve this?
Thanks in advance
|
|
|
Powered by
FUDForum. Page generated in 0.03503 seconds
] 
Search
Help
Register
Login
Home
