Using the Conditional Formatting and Format Exception dialog boxes, you can specify output formatting attributes (font and color) for a selected layout object based on conditions that exist. The conditions that you define are called format exceptions.
You can display the Conditional Formatting dialog box from the Paper Layout view or Paper Design view in any of the following ways:
Double-click the object to display the Property Inspector. Under the General Layout node, click the Conditional Formatting value field (labeled ...).
Display the pop-up menu (right-click in Windows) for the object.
Click the object, then choose FormatConditional Formatting.
The Format Exception dialog box displays when you click New or Edit in the Conditional Formatting dialog box, and enables you to quickly and easily specify output formatting attributes for a selected layout object based on defined conditions. After you specify conditions and formatting for the current layout object in the Format Exception dialog box, the entire definition is exported to a PL/SQL format trigger. If a format trigger already exists for the layout object, the definition in the Format Exception dialog box overwrites the existing trigger code when you confirm the Reports Builder prompt.
You can edit the format trigger manually with the PL/SQL Editor; however, if you subsequently modify the definition using the Format Exception dialog box, Reports Builder displays a prompt to overwrite the existing format trigger.
For a detailed example, see the chapter "Building a Report with Conditional
Highlighting" in the Oracle Reports Building Reports manual,
available on the Oracle Technology Network
Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html
).
Applying conditional formatting to a layout object
Copyright © 1984, 2005, Oracle. All rights reserved.