The Conditional Formatting Rules dialog lets you define rules that when fired change the style formatting of the selected item. You can define multiple rules that will format the same report item. Each rule is made up of a set of conditions and a style to use when the conditions of the rule are met. Rules are executed in the order they appear in the ConditionalFormatting collection. You can choose whether to continue evaluating all rules in the collection or interrupt execution when a rule is satisfied.
Use the New Rule, Edit Rule and Delete Rule buttons to add, edit and delete formatting rules. Use the arrow buttons to change the order of precedence where rules higher in the list are evaluated before rules occuring later in the list. Select the Stop if true checkbox to interrupt rule processing if the rule conditions are satisfied.
The New Rule and Edit Rule buttons display the Edit Formatting Rule dialog. The top portion of the dialog contains a list of rules. Each rule consists of an Expression an Operator and a Value. Expression can be a database field defined in the Report DataSource or "<Expression>". "<Expression>" invokes the Edit Expression Dialog. Operator lists comparison operators (i.e. <, >, >=, etc.), Like, Top N, Top %, Bottom N and Bottom %. Value can be a hard coded value, "<Blank>" or "<Expression>". Rules expressions are "and-ed" together and must all be true for the rule condition to be satisfied.
The bottom portion of the Edit Formatting Rule dialog has a button to invoke the Edit Style dialog and a preview of the style.
The Style button displays the Style Builder dialog
that sets the formatting to be used if the rule conditions are satisfied. Here
you can define the style for Text, Background,
Edges, Line styles as well as whether an item/section would be visible or not.