<exception>
XML tagThe <exception>
tag delimits
a formatting exception that you want to apply to a field (for example, the field
should turn red when the value exceeds some limit). The <exception>
tag must be nested within a <field>
tag. It must also have a <condition>
tag nested within it that defines the condition under which to apply the formatting
exception.
<exception
[lineColor="color_name | noLine"]
[fillColor="color_name | noFill"]
[textColor="color_name"]
[hide="yes | no"]
[font="font_name"]
[fontSize="point_size"]
[fontStyle="regular | italic | bold | boldItalic"]
[fontEffect="regular | strikeout | underline
| strikeoutUnderline"]>
condition_definition
</exception>
Parameters /Options |
Description |
||||
lineColor
|
Is the name of the border color to apply
when the condition is met. If |
||||
|
Is the name of the fill color to apply when
the condition is met. If |
||||
|
Is the name of the text color to apply when the condition is met. |
||||
|
Determines whether to hide the field when the condition is met.
|
||||
|
Is the name of the font to apply when the condition is met. |
||||
|
Is the size of the font to be used when the condition is met. |
||||
|
Is the style of the font to be used when the condition is met. |
||||
|
Is the effect of the font to be used when the condition is met. |
Exceptions are processed in the order they appear in the field.
Each exception can have up to three conditions.
There is no limit on the number of exceptions that can be applied to a field, except for the PL/SQL maximum length restriction for the resulting format trigger.
If multiple exceptions exist, then they are controlled by an implicit OR relation, which means that as soon as one of the exceptions has been applied (that is, satisfied), no other exceptions will be processed.
The following example shows two formatting exceptions for field f_ename
.
The first exception changes the text color to red if both of its conditions
are met. The second exception changes the text color to blue if its condition
is met.
<field name="f_ename" source="ename"
label="Employee" textColor="green">
<exception textColor="red">
<condition source="deptno" operator="btw"
operand1="1"
operand2="20" relation="and"/>
<condition source="sal" operator="gt"
operand1="1000"/>
</exception>
<exception textColor="blue">
<condition source="deptno" operator="eq"
operand1="30"/>
</exception>
</field>
Copyright © 1984, 2005, Oracle. All rights reserved.