User Tools

Site Tools


Payroll Item Summary using Pivot Reporting

This report provide information about the worksheet detail of each employee.

  • From the Payroll main navigator menu, go to Payroll Forms and Reports>Available Reports>Payroll Item Summary.
  • Then click the [Run] button.
  • Enter the Period Start and End dates and build the report by clicking the [Build Report] button.
Please take note that the dates being referred to in this report is the period date and NOT the Processed date
  • Once the report, has been built, all the information will be shown in the Results *Preview* tab. However, since this is designed for pivot reporting, go the to the Pivot *Preview* tab.
  • In this screen, we need to identify the row, column, and data fields.
  • In this report since this is supposed to be and information per employee, drag the employee name field towards the “Drop Row Fields Here” area.
  • Then drag Description field towards the “Drop Column Fields Here” area, as well as the EE Share and ER share fields towards the “Drop Data Fields Here” area.


  1. The report generated can be exported to an excel file as well as print it.
  2. To print, click the [Print] button to preview the report first.
  3. From the Print Preview screen, click the [Design] button in the toolbar to format the report.
  4. Set the the Title of the report through the [Title Properties] button.
  5. Set the view settings as shown below:
  6. Then the behavior as:
  7. Set the font styles by setting the Font, Color, and Texture.
  8. When exiting out of the custom report, click the [Save] button in the toolbar.
employee_summary_detail_report.txt · Last modified: 2018/08/09 20:01 by rreyes