AnsweredAssumed Answered

Need Serial Number in Report

Question asked by ajyad99 on Jun 3, 2010
Latest reply on Jun 3, 2010 by ajyad99


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.