Reporting
User Guide
Create Reports : Styles and Conditional Formatting : Conditionally Change a Control's Appearance
Conditionally Change a Control's Appearance
Refer to Styles Concepts for further information on using styles in Reporting.
|
•
|
|
•
|
Select the report by clicking anywhere on the blank area around its band. In the Property Grid, locate the Formatting Rules Sheet property and click the ellipsis. The Formatting Rule Sheet Editor is then displayed. This is used to manage and customise formatting rules, which then can be applied to the report's bands and controls.
|
In this window, create a new formatting rule (click 
), locate its Condition property and click the ellipsis.
), locate its Condition property and click the ellipsis.
|
•
|
In the displayed Condition Editor, define the required Boolean condition. In this example, the condition defined is that if the UnitPrice is greater than 30 the fields will be formatted.
|
|
•
|
Select the band or control to which the formatting rule must be applied (in this example it is the Detail band), and in the Property Grid, locate the Formatting Rules property and click the ellipsis. In the Formatting Rules Editor that is then displayed, move the formatting rule from the Available Rules list to the Applied Rules list (using the > button) in order to apply the rule to the control.
|
It is possible to customise the precedence of formatting rules by using the up and down arrow icons at the right of the window. Rules are applied in the order that they appear in the list, with the last rule in the list having the highest priority.
