Running Totals by hand??

[dnovakoff]

Hi,

I am having a crazy problem. I have two groupings, A and B, with B nested within A.

I am trying to keep a running total of distinct record ids within B. To do this I imagine I need to initialize a global variable to zero in the header (before section) of Group A, increment it in the header of Group B, and then spit out the variable value in the footer (after section) of Group A.

Seems like simple logic...but, using message boxes I'm noticing that no matter what methods I choose, the Group A header fires first, the Group A FOOTER fires next, and THEN the Group B detail lines loop. How is it that the report jumps from the header, to the footer, and THEN the nested group details?? This seems completely backwards to me, and working this way I can not keep a manual running total accurately.

Please any help would be greatly appreciated...am I missing the correct methods to override that would fix this problem?
Thanks,
Dave

 

[dknlght]

Dave,

Why don't you use a textcontrol and place the Aggregate functions count() under valueexp. then place the textcontrol in the After section of the group frame A. This will give you a count of group A's

then have group frame B in the content section of group frame A and put a similar textcontrol in it's After section too. this will then give you the count for B