Numbering items in a grouped report

I am doing a report for school. I have it set up by Teacher's name and then
a list of students in each teacher's class. I have inserted a number symbol
to count the students, but I would like the numbers to start at ONE for each
teacher, so we can tell at a glance how many kids are in each room. I could
do this by have a subtotal of students show for each teacher but would
prefer to do it by have the numbers restart for each change in teacher. I
have tried it a few ways but can not get FMP 8.5 on my Windows XP computer
to do it. Any suggestions would be appreciated!

This is the look I am trying to get:

Teacher
1 student
2 student
3 student

Second Teacher
1 student
2 student
3 student, etc.

In article , "lariveesl"
wrote:

> I am doing a report for school. I have it set up by Teacher's name and then
> a list of students in each teacher's class. I have inserted a number symbol
> to count the students, but I would like the numbers to start at ONE for each
> teacher, so we can tell at a glance how many kids are in each room. I could
> do this by have a subtotal of students show for each teacher but would
> prefer to do it by have the numbers restart for each change in teacher. I
> have tried it a few ways but can not get FMP 8.5 on my Windows XP computer
> to do it. Any suggestions would be appreciated!
>
> This is the look I am trying to get:
>
> Teacher
> 1 student
> 2 student
> 3 student
>
> Second Teacher
> 1 student
> 2 student
> 3 student, etc.

The easiest way is to have a Script that loops through numbering each
record and then prints the report.

The Script needs to temporarily store the "current" group's teacher
name to check against each record so that when the next teacher name is
found the counter number can be reset back to 1.
eg.
Sort Records [Restore]
Go To Record [First]
Set Field [g_Counter, 1]
Set Field [g_CurrentTeacher, Teacher]
Loop
If [Teacher = g_CurrentTeacher]
Set Field [Student Number, g_Counter]
Set Field [g_Counter, g_Counter + 1]
Else
Set Field [g_Counter, 1]
Set Field [g_CurrentTeacher, Teacher]
Set Field [Student Number, 1]
End If
Go To Record [Next, Exit After Last]
End Loop
Go To Layout [MyReport]
Page Setup [Restore, No Dialog]
Print []
Go To Layout [MyDataEntry]

Where the stored Sort order is something like:
Teacher Increasing
Student Surname Increasing
Student First Name Increasing

and the two "g_" Fields are new Global Fields.

g_Teacher Global, Text
g_Counter Global, Number

Then whenever you need this report you need to Find the appropriate
records and then run this Script.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)