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

    Need Serial Number in Report

    ajyad99

      Title

      Need Serial Number in Report

      Post

      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.