Database Reference
In-Depth Information
Next, remove
STATUS_ID
and replace it with the corresponding value, pulled into
the report by a slight adjustment to your query:
1.
Edit
Page 200
in your application.
2.
Edit the report attributes again by right-clicking the
Tickets
region and se-
lecting
Edit Report Attributes
.
3.
Click the
Query Definition
subtab near the top of the page.
4.
Click the
Add/Remove Columns
button.
5.
See
Figure 6-35
. Ensure that
Table/View Owner
is set to your schema
name and that
Show Related Tables Only
is set to
Yes
.
Figure 6-35.
Selecting report columns
6.
Set
Table/View Name
to
STATUS_LOOKUP
, and wait for the page to re-
load.
7.
Select the
STATUS
column in the
Select Columns
list to the left, and move
it to the
Columns Selected
list by clicking the
>
icon.
8.
From the
Columns Selected
list, remove the
TICKETS.STATUS_ID
column by selecting it and clicking the
<
icon.
9.
Click
Next
to verify the join conditions. You see the dialog in
Figure 6-36
.