Example of Area Chart SQL Template: Allocated Available
From the Template Designer tab, click Query custom combo box.
With the selected, click .
In the field, enter the heading that will display in the report template's scope selector drop-down list. For example Array Vendor.
In the field, enter the SQL query that returns a list of values that will be available in the combo box:
SELECT DISTINCT vendor_name,vendor_name FROM aps_v_storage_array UNION ALL SELECT ' All', ' All' FROM dual ORDER BY 1
Click and .
Click the tab and enter the following. This query will use the value selected in the populated combo box to retrieve the data to be rendered in the report. The custom combo variable is represented as ${queryCombo1} in the query.
SELECT Array_name, allocated_gb, available_gb FROM aps_v_storage_array WHERE '${queryCombo1}' IN CASE WHEN '${queryCombo1}' NOT IN (' All') THEN CASE WHEN vendor_name = '${queryCombo1}' THEN '${queryCombo1}' END ELSE ' All' END ORDER BY available_gb DESCClick the tab.
In the window, select or from the drop-down list.
For the field, select from the drop-down list.
Select all the fields to be displayed.
Assign a color to each field that will be displayed as an area. In the example, assign a color to the fields and .
Assign a name for the report template and save it to a report menu group. You can also assign sharing if required.
Generate a report from the new template. The output will look similar to the following example:
