-
Click Custom Reports.
-
Click
.
-
Enter a name for the report, up to 20 characters.
You can use alphanumeric characters and underscore (_), but no space.
-
Select a report type from the list.
-
[Optional] Enter a description.
For bar and line charts, use the description to help report users understand the units of measure for the x axis and y axis.
-
Enter SELECT statements in the SQL box.
The first SELECT statement displays as the X axis in the bar and line charts. Subsequent SELECT statements display as the Y axis.
-
Click Apply.
After you create the report, it is available to view in the Report Viewer portlet.