Using Report Builder, you can write a query using the Query Builder or select the required columns in the report and generate reports based on your requirements.
To generate a report:
- Select Admin > Basic > Infrastructure > Report Builder.
- On the REPORT BUILDER page, click ADD NEW on the ACTIONS panel.
- Under the Details section, fill in the required details and click NEXT. For more information about the fields on the REPORT BUILDER page, see Field Description.
Figure: REPORT BUILDER page: Details page - Under the Designer tab, you can select the Use Query Editor check box to write the query in the SQL Query text box. The Use Graph option is not available for the Tabular Report type.
- Or, select the column you want to be displayed in the report from the Select Columns section. If you select the Filters check box, the selected column becomes a filter/search criteria in your report. Similarly, you can select fields that can be used for sorting by selecting the Sort check box.
- The selected columns are displayed in the Column Re-Order & Grouping section. You can also change their sequence by moving them up and down.
- The columns that you select for filter are displayed under the Filters section. Similarly, the columns that you select for sorting are displayed under the Sort Columns section. You can choose their sorting order by moving them up and down.
- Once you have selected the columns for the report, the filter options and the sort options, click VALIDATE QUERY. It will automatically generate a query based on your selections in the SQL Query text box.
- Click Preview to view the preview of the report.
Figure: CUSTOM REPORT BUILDER page: Designer tab - Under the Preview tab, select the required filter options on the FILTERS pop-up page and click SUBMIT (see, Filters). The preview of the report is displayed based on the filter criteria.
Figure: CUSTOM REPORT BUILDER page: Preview tab
Field Description
The following table describes the fields on the CUSTOM REPORT BUILDER page:
Field | Description |
|---|---|
Details | |
Tenant | Lists all the configured Tenants. Select a Tenant from the list. |
Module Name | Lists all the configured modules for the selected Tenant. Select a module from the list. |
Report Type | Select the report type from the list Tabular Report or List Report. |
Report Name | Type in a name for the report. |
Access Type | Select the access type from the list.
|
Active | Indicates the status of the report.
|
Designer | |
Use Graph | Select this option to create a graphical report. |
Use Query Editor | Select this option to type the query string directly in the SQL Query text box. |
Select Columns | Select the columns you want to be displayed in the report. |
Column Re-Order Grouping | Displays the columns you have selected to be displayed in the report. You can also change their sequence by moving them up and down. |
Sort Columns | Displays the columns you have selected for sorting. You can also change their sequence by moving them up and down. |
Filters | Displays the columns you have selected for filter. |
SQL Query | Displays the SQL query based on your selection. |
Preview | Displays the preview of the report. |
ACTIONS
This section explains all the icons displayed on the ACTIONS panel of the REPORT BUILDER page.
Click the Filters icon to specify a particular filter criteria to display the custom reports. On clicking the Filters icon, the FILTERS pop-up page is displayed. Select the Tenant, Module Name, and Report Type. Click SUBMIT.
Figure: FILTERS pop-up page
Click SHOW LIST to display the LIST table showing all the custom reports for the selected Tenant.
Figure: CUSTOM REPORT BUILDER page: List of reports
- To edit a report, click the Report Name. Make appropriate changes and click SUBMIT.
- To display the inactive reports, click the Include Inactive check box.
Note:
When the reports are displayed under the LIST table, the ADD NEW action is displayed on the ACTIONS panel. Click ADD NEW to configure a new custom report.