How to print the number of groups in page footer

[mkrausnick]

This has probably been answered but search appears to not be working right now. How can I print in the page footer the number of groups that appear on each page?

Thanks,

Mike Krausnick
Dublin, California

 

[mkrausnick]

I'm not sure if this is the simplest way, but here's what I did that worked:

1) Create a report variable r_GroupCount with this formula in the 'Value to Store':

iif(GroupId <> r_LastGroupId,1,0)

InitialvValue 0, reset on page break, calc type sum.

2) Create a second report variable r_LastGroupId with this formula in the Value to Store:

GroupId

Initial value 0, reset on report, calc type none

3) Place r_GroupCount in the page footer

Mike Krausnick
Dublin, California

 

[Mike Gagnon]

Mike

If you can read French (some of the instruction are in French)

http://www.atoutfox.com/articles.asp?ACTION=FCONSULTER&ID=0000000405

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)