Difference between revisions of "Custom Reports"
From TrueERP wiki
| Line 21: | Line 21: | ||
[[Transfer Employee Data]] | [[Transfer Employee Data]] | ||
</menu> | </menu> | ||
| − | == Overview == | + | == 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.
