Need Serial Number in Report
I am using Filemaker 8.5.
I have created a database to prepare salary for a organization. When I print Salary Summary Report I want to add Serial Number starting from 1 for first employee and a increment of 1 to next employee for a department. At the end of each department I want to display the count of employees for that department. When the report goes to next department the serial number should again start from 1.
Right now I am using @@ to display serial number starting from 1 but when the next department comes this number is incrementing and not reseting to 1 because it is showing record number.
Do I need to use a field or a script to implement this?
Thanks in advance.