Creating a report by editing the SQL statement
About this task
If you know SQL, you can create a custom report by editing the SQL query that is used to generate an existing report. To edit the SQL, complete the following steps:
Procedure
- To generate your base report, perform step 1 . Generate the base Report
- Click .
- In the SQL data field, make the changes to the SQL.
- There are 2 options available now.
- Click Run Report.
-
If the generated report is what you require, go to step 7,
otherwise, complete the following actions.
- Click .
- Repeat from step 3 until the report meets your requirements.
- Select .
- Change the name in the Query name field to one relevant for the new report.
- Change or delete the description in the Description field.
- Enter a menu name. This name is displayed as a menu item in the Custom Reports menu.
-
Select any groups that can have access to this report.
Note: The created report is displayed only in the Custom Reports menu of the Admin user or Super User who created the report. If groups are selected, the report is also displayed in the Custom Reports menu of any users who are members of the selected groups.
- Click Submit.