Database Reference
In-Depth Information
Figure 6-51.
The Tickets report region source with the search filter
Here you see that this region type is SQL Query. The source for this region is your
SQL query on the
TICKETS
table with the modified
WHERE
clause to add the filter on
the
P200_SEARCH
item, referencing
P200_SEARCH
as a bind variable.
Clicking the Report Attributes tab at the top of the page, you see a series of attribute
regions. A list of table columns appears in the Column Attributes region, shown in
Fig-