Database Reference
In-Depth Information
Figure 7-12.
Specifying the page number, name, and breadcrumbs for an interactive re-
port
8.
Set
Tab Options
to
Use an existing tab set and create a new tab within
the existing tab set
. When the page refreshes, set
Tab Set
to
TS1 (Home,
Figure 7-13.
Specifying tab options for an interactive report
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
,