To highlight a value in a report:
In the Paper Layout view or Paper Design view, click the field that contains the value to be highlighted.
Choose FormatConditional Formatting.
In the Conditional Formatting dialog box, click New to display the Format Exception dialog box.
Select the field and define the condition(s) when the value should be highlighted.
In the Format group box, select the Fill Color to be used to highlight the value.
Note: If you can't select the condition you want to use in the dialog box, select the formatting you want and a placeholder condition. The condition can be edited in the PL/SQL Editor for the format trigger that is created.
Suppose that you are building a banking report and would like it to indicate if a customer is overdrawn. To do so, you give the repeating frame around the customer information a format trigger that causes it to have a border only if a customer's account balance is less than 0 (or the required minimum balance).
function my_formtrig return BOOLEAN is
begin
if :bal < 0 then
srw.set_border_width := 1;
end if;
return (true);
end;
Applying conditional formatting to a layout object
Creating or editing a format trigger
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
).
Copyright © 1984, 2005, Oracle. All rights reserved.