I have a report that has more than one group, for example, group one is by <b>STUDENTID</b> and group two is by <b>ATTENDANCE</b>. I only want to count my <b>STUDENTID</b>, not count all records in all groups. Any way to repress a group in counting records?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Counting Groups
- Thread starter dominator
- Start date
You can use variables to handle this. This requires 3 formulas to work. <br><br>Formula 1 (Placed where you want the count to begin):<br>WhilePrintingRecords;<br>NumberVar StudentIDCounter:=0<br><br>Formula 2 (Placed in the header of your STUDENTID group):<br>WhilePrintingRecords;<br>NumberVar StudentIDCounter=StudentIDCounter + 1<br><br>Formula 3 (Placed where you want to see the total count):<br>WhilePrintingRecords;<br>NumberVar StudentIDCounter;<br>StudentIDCounter
- Status
Similar threads
- Locked
- Question
- Locked
- Question