A script-enabled browser is required for this page to function properly.

Highlighting a value

To highlight a value in a report:

  1. In the Paper Layout view or Paper Design view, click the field that contains the value to be highlighted.

  2. Choose Formatright arrowConditional Formatting.

  3. In the Conditional Formatting dialog box, click New to display the Format Exception dialog box.

  4. Select the field and define the condition(s) when the value should be highlighted.

  5. 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.

  1. Click OK to close the Format Exception dialog box, then click OK again to close the Conditional Formatting dialog box. If the code compiles without errors, the new formatting is reflected in the Paper Layout view. The code is stored as a format trigger for the field.

Example

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;

See also

About conditional formatting

Applying conditional formatting to a layout object

Highlighting a row

Alternating row colors

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).