Custom ReportsEnglishالعربيةfrançaisTagalogहिन्दी

• More Detail

Access Levels Clock On Custom Reports Employee Barcodes Employee List Employee Reports Employee Summary Report New Employee Personal Preferences Rep Rep List Roster Roster List Services Rep Timesheet Timesheet List To Do To Do List Transfer Employee Data

Overview

The Employee Custom Reports enables the User to create new Template Reports with the use of SQL strings. These Reports should only be created by someone with a very good understanding of the SQL layout. [[LearnReportBuilder.pdf<File=LearnReportBuilder.pdf>]]

How to Create Custom Reports

· All the Templates within ERP have been created with the use of the SQL strings. To view these please go to the General Tab and then Templates.

· Click on the Template Tab to open.

· You can then choose your required Template by double clicking.

· Each Template has been created by the SQL String located at the bottom of the Template Selector.

· These SQL Strings put your templates together.

· Highlight these strings and copy.

· Then paste the SQL String into a Word Document to view.