Database Reference
In-Depth Information
11.
Paste the contents of the file
ch7_query.txt
into the
Enter SQL
Query or PL/SQL Function Returning a SQL Query
region, or type the
previous query into the region, and click
Next
.
12.
Click
Create
.
Run the page. Your chart should look similar to the one in
Figure 7-77
.
Figure 7-77.
The Ticket Statuses chart
Filtering Data Using a Chart
The link that you included in your SQL statement passes a status value to the
P200_STATUS_ID field on page 200. However, you haven't created that item yet. The
next steps create the item P200_STATUS_ID on page 200 so that when a slice of the
chart is clicked, the report can filter based on the status:
1.
Edit
Page 200
of the application.