4 Replies Latest reply on Jun 3, 2010 9:55 AM by ajyad99

    Need Serial Number in Report



      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.