 |
|
Oracle Tips by Burleson |
Highlighting Words in a Report
As we saw in chapter 4 when we did a search the
search word was highlighted in each of the fields wherever it was
found in the report. The next step will be to show you how to do that
in this report.
1.
Once again click on the Edit Page 11 link in the developer
toolbar.
2.
Click on the Report link as shown in Figure 7.2 to navigate
directly to the Report Attributes page.
3.
Click on the link
next to the LAST_NAME column.
4.
Go to the Highlight Words page item in the Column Formatting
region and enter the text: &P11_REPORT_SEARCH.
5.
Take note the trailing period that must be there as shown in
Figure 7.4. This is referred to as Exact Substitution.
6.
Click Apply Changes.
Save time by using the button
in the upper right area of the Column Attribute page. This will save
the changes and navigate to each of the next columns in the report.
On the last page click Apply Changes.
7.
Repeat the setting of the Highlight Words page item for the
following report columns: FIRST_NAME, EMAIL, COMPANY, PAYMENT TYPE.
Test the work by running the report.
8.
Type in the text AM in the Search page item and press the Enter
key.
A full screen of results should be visible with
the text am in red, bold letters everywhere there is a match. Isn’t
this exciting! These are the kinds of things that are built into HTML
DB that eliminate developers from having to develop their own
programming logic to do it.
The above book excerpt is from:
Easy HTML-DB
Oracle Application Express
Create Dynamic
Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent
Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm |
