Difference between revisions of "Custom Reports"
From TrueERP wiki
(Created page with "<menu name=myMenu align=center> Related Items= Access Levels Clock On Custom Reports Employee Barcodes Employee List Employee Reports [[Employee Summary R...") |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
<menu name=myMenu align=center> | <menu name=myMenu align=center> | ||
| − | + | More Detail= | |
[[Access Levels]] | [[Access Levels]] | ||
[[Clock On]] | [[Clock On]] | ||
| Line 21: | Line 21: | ||
[[Transfer Employee Data]] | [[Transfer Employee Data]] | ||
</menu> | </menu> | ||
| + | == 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. | ||
Latest revision as of 09:59, 1 March 2011
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.
