Databases Reference
In-Depth Information
For this report you're going to use the
TICKETS_V
view instead of the
TICKETS
table directly. The view joins the
TICKETS
table to the
STATUS_LOOKUPS
table so you don't have to do it manually later at the column level:
9.
Enter
SELECT * FROM tickets_v
in the
Enter a SQL SELECT Statement
region, set
Uniquely Identify Rows by
to
Unique Column
, enter
TICKET_ID
for
Unique Column
, and
click
Next
(see Figure
7-14
).
Figure 7-14.
Entering a SQL SELECT statement for an interactive report
10.
Click
Create
.
Running an Interactive Report
Run the application, and navigate to the Analysis tab. The page looks similar to Figure
7-15
. At first glance, the
interactive report looks no different than any other APEX report. However, the interactive report can perform a
number of functions that a standard APEX report can't.