Last modified by: Kevin Zimmer -

Active Employees by Department

What: Know who and how many employees are working in each department.

Base Report: Employee Details

1. Layout

      • Click Layout to hide columns which we are not needed in this report.
      • Uncheck the following columns:
        • Classification
        • Contracted Hours
        • SIN
        • Birth Date
        • Home Dept. Code
        • Federal TD 1
        • Provincial TD 1
        • RP Account
      • Click OK.

 

      • You can, of course, choose to leave any of the above columns visible for your report.

 

2. Filter

      • Click Filter so we can isolate the Active employees only.
      • Use the following settings:
        • Filter ColumnStatus
        • Comparison: =
        • Value: Active
      • Click Add.

 

      • Note that when using the = operator for the Comparison field, the value entered must exactly match (both spelling and format) the criteria you are looking for.

 

3. Group

      • Click Group so we can organize our report by department.
      • Use the following settings:
        • Grouping ColumnHome Dept. Name
      • Click Add.

 

4. Sort

      • Use the Sort button to order the employees in each department alphabetically.
      • Use the following settings:
        • Data ColumnName
        • Order Direction: Ascending
      • Click Add.

 

5. Saving
      • Scroll down below your table.
      • If this report is to be viewed by only the report creator, check off Private Report.
      • Click Save As.
      • Enter the desired report name in the Custom Report Name field.
      • Click Add a Bookmark.

 

    • Your report is now saved. Next time you go under the Reports tab of the main menu, your report will appear in the report listing table.

Contact the Alpine Crew!

204-478-3707
alpinecrew@ibexpayroll.ca