Custom grouping report

[mmiklauz]

Hi!



I have a report with one group level which gives me total of 8 groups. Now I want do add a new group which will give me (like conditional grouping?) sum below first 6 group and below last 2. Any idea?

[ranman256]

insert Group Footer, into the report
put the sum field, =sum(field), in the group footer.

for a total footer, add an extra field in the query, like: Title: MyReport
add this Title Group as the outer most Group
put the same Sum field in its footer to get the total of all groups.

[mmiklauz]

Sorry but I don't understand how I will get total for only first 6 groups?

[mmiklauz]

Maybe i wasn't clear enough, Now I have 8 groups total, I want to add second group and show totals for only first 6 groups, not the last 2.

[ranman256]

in the query, add a field using the group name of the 8.
in the say: tDepts table
Dept, Group
1, Finance
2, Finance
3, I.T.
etc

add tDepts table to the query , join on the field, add the Group
now you can sum all 8 Depts under 1 Group.

[mmiklauz]

in the query, add a field using the group name of the 8.
in the say: tDepts table
Dept, Group
1, Finance
2, Finance
3, I.T.
etc

add tDepts table to the query , join on the field, add the Group
now you can sum all 8 Depts under 1 Group.

Thank you!