Query about Nesting Groups

[kentran]

I am nesting two groups.
What I need is a total at the bottom of the 1st group that shows totals for the two sub groups like so:

Accepted Transactions
AM Transactions
item 1
item 2
item 3

PM Transactions
item 1
item 2

--
3 AM Transactions
2 PM Transactions

Rejected Transactions
AM Transactions
item 1
item 2

PM Transactions
item 1

--
2 AM Transactions
1 PM Transactions


How do I achive this?

 

[Hattusas]

A way to solve this problem is, to use formulas.First you must declare your variables with initial values = 0;
Your formula should be like this...
whileprintingrecords;
numbervar itemcount:=0;
this formula must be supressed and placed on your transactions group header ...Then in your detail section, your new formula should be :
whileprintingrecords;
numbervar itemcount;
itemcount:=itemcount+1;
of course it should be supressed.
Finally in your footer part, your third formula should be
whileprintingrecords;
numbervar itemcount;
//Write whatever you want to be printed
Of course it is not to be supressed ).
I don't prefer using subtotals because in details section there can always be significant changes.For example in my records the count of room names are always wanted but for example if they are triple they must be omitted.So running sub totals can't achieve this.But using formula is very flexible.You can perfom many miracles Do not forget to add Whileprintingrecords; token.