/
Report Builder
Report Builder
Adding a new Report
- Click Report → Report, then click Add New.
- Fill the applicable data fields. Then click Save
Tab Report
If the Template Type is CrystalReport you need to upload the Crystal Report template file.
Tab Report Filters
Click Add New to add a new Report Filter
Fill out the applicable data fields. Then click Save.
Filter*: all the Filter defined in the system.
Db Column*: will be used when building the final SQL query for the report.
Parent Filter*: will define the cascading behavior.
Tab Report Query
SQL*: this is a normal SQL query with 2 special token /**where**/ and /**orderby**/. The token /**where**/ will be replaced by the Report Filters (after translated to SQL conditions).
Sort Expression*: will replace the token /**orderby**/
Include Current User In Query*: if true then add the condition User.Id = currentUserId to the SQL WHERE condition.
Tab Report Columns
Click Add New to add a new Report Column
Fill out the applicable data fields. Then click Save
Column Name*: is the column returned from SQL query
Tab Security Groups
Specify the Security Groups that can see this report
, multiple selections available,
Related content
Overview
Overview
More like this
Dashboard Builder
Dashboard Builder
More like this
Filter
Filter
More like this
A Typical Scenario of Work Order
A Typical Scenario of Work Order
More like this
Assignment Group
Assignment Group
More like this
Item Group
Item Group
More like this