 |
|
Oracle Tips by Burleson |
Adding
the Search Field to the Report
Adding a search field to the report is a two step
process:
This same process would be used to provide several
search fields. That will be covered in the Add Query By Example to a
Report section later in this chapter.
To create the search page item in the report
region, click on the Edit Page 11 link in the developer toolbar. This
goes to the Page Definition page.
1.
On the Page Definition page, click on the  icon
in the Items section.
2.
On the Item Type page choose the Text option and click Next.
3.
On the next page choose the Text Field (always submitspage when Enter pressed) option and click Next.
This option will do just what it says.
When the user presses the Enter key while in the search page item, the
page will be submitted.
4.
On the Display Position and Name page:
Click Next.
5.
On the Item Attributes page:
-
Label: Search.
-
Label Alignment: Right.
-
Field Width: 50
The field width is used to indicate how
wide to make the page item when rendering it in an HTML web page. The
field width in this example will be set at 50 since that is the text
length of the largest column that will be searched.
6.
On the Source page:
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
