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