i'm creating a sectioned report and requires counts as below
group: aaaaa
subgroup rectype1 rectype2 rectype3 total
1-aaaaaa 1 0 5 6
2-aaaaaa 0 1 2 3
group: bbbbb
subgroup rectype1 rectype2 rectype3 total
1-bbbbbb 4 0 5 9
2-bbbbbb 5 9 1 19
i sort the input on group, subgroup and rectype
the group, subgroup breaks and the rectype count i'm able to tally. where i need help is lining the counts horizontally under the correct record type.
any help will be appreciated.