Edit Conditions dialog

The details and functions of the dialog vary according to different source it is opened from.

If it is opened by clicking the button or in the Conditional Formatting dialog, Insert Link dialog for page report or web report/library component, Edit Link dialog for page report or web report/library component, or clicking the Add or Edit button in the Shape Map Area Conditional Formatting dialog, it is used to add a new or edit an existing condition for the selected object, the geographic map markers, or the shape map areas, on which some format is defined. See the dialog.

The options in the dialog are as follows.

Add Condition

Adds a new condition line.

Delete

Deletes the selected condition line.

Group

Makes the selected conditions in a group. Conditions can also be added to an existing group by selecting the conditions and the group while holding the Ctrl button, and then clicking the Group button.

Ungroup

Makes the selected condition ungrouped.

Up

Moves the selected condition or group up to a higher level.

Down

Moves the selected condition or group down to a lower level.

Logic

Lists the logic operator.

• And
  Logic operator And which is applied to this and the next line.
• Or
  Logic operator Or which is applied to this and the next line.
• And Not
  Logic operator And Not which is applied to this and the next line.
• Or Not
  Logic operator Or Not which is applied to this and the next line.

Field

Specifies the field on which the condition is based.

Operator

Specifies the operator to compose the condition expression.

• =
  Equal to
• >
  Greater than
• >=
  Greater than or equal to
• <
  Less than
• <=
  Less than or equal to
• !=
  Not equal to

Value

Specifies the value of how to build the condition.

• If you are editing conditional link or conditional formatting on a field, you can either type in the value manually or select the value from the drop-down list, where the top 50 values of the selected field are listed.
• If you are editing conditional formatting on map areas, type in the value manually or click the button next to the value text box to specify the value.

Condition Expression

Displays the condition expression.

OK

Applies the changes and closes the dialog.

Cancel

Cancels the changes and exits the dialog.

Help

Displays the help document about this feature.

If it is opened by clicking in the Format Bar/Line/Pie/Donut dialog, it is used to add more complicated conditional fill to the values of a chart. The options in the dialog are as follows. See the dialog.

Select Query for Value Field

Specifies the query which contains the fields you want to use as the values to build the condition.

Add Condition

Adds a new condition line.

Delete

Deletes the selected condition line.

Group

Makes the selected conditions in a group. Conditions can also be added to an existing group by selecting the conditions and the group while holding the Ctrl button, and then clicking the Group button.

Ungroup

Makes the selected condition ungrouped.

Up

Moves the selected condition or group up to a higher level.

Down

Moves the selected condition or group down to a lower level.

Logic

Lists the logic operator.

• And
  Logic operator And which is applied to this and the next line.
• Or
  Logic operator Or which is applied to this and the next line.
• And Not
  Logic operator And Not which is applied to this and the next line.
• Or Not
  Logic operator Or Not which is applied to this and the next line.

Field

Specifies the field on which the condition is based.

Operator

Specifies the operator to compose the condition expression.

• =
  Equal to
• >
  Greater than
• >=
  Greater than or equal to
• <
  Less than
• <=
  Less than or equal to
• !=
  Not equal to

Value

Specifies the value of how to build the condition.

Condition Expression

Displays the condition expression.

Color

Specifies the color that will be applied to the chart values which meet the condition. Select a field from the drop-down list to control the color. If the given fields cannot meet your requirement, you can click <Input...> and then input the value directly in the text box.

Transparency

Specifies the transparency of the color. Select a field from the drop-down list to control the transparency. If the given fields cannot meet your requirement, you can click <Input...> and then input the value directly in the text box.

Value

Specifies to display the data in the condition expression as value. The option only applies to pie chart, 100% Stacked Bar/Bench 2-D chart, 100% Stacked Bar/Bench 3-D chart and 100% Stacked Line 2-D chart, and only when the field which the condition is based on is value field.

Percent

Specifies to display the data in the condition expression in percent. The option only applies to pie chart, 100% Stacked Bar/Bench 2-D chart, 100% Stacked Bar/Bench 3-D chart and 100% Stacked Line 2-D chart, and only when the field which the condition is based on is a value field.

OK

Applies the changes and closes the dialog.

Cancel

Cancels the changes and exits the dialog.

Help

Displays the help document about this feature.

If it is opened by clicking the button in the Edit Values dialog. It is used to compose an expression for retrieving field values. See the dialog.

The options in the dialog are as follows.

Add Condition

Adds a new condition line.

Delete

Deletes the selected condition line.

Group

Makes the selected conditions in a group. Conditions can also be added to an existing group by selecting the conditions and the group while holding the Ctrl button, and then clicking the Group button.

Ungroup

Makes the selected condition ungrouped.

Up

Moves the selected condition or group up to a higher level.

Down

Moves the selected condition or group down to a lower level.

Logic

Lists the logic operator.

• And
  Logic operator And which is applied to this and the next line.
• Or
  Logic operator Or which is applied to this and the next line.
• And Not
  Logic operator And Not which is applied to this and the next line.
• Or Not
  Logic operator Or Not which is applied to this and the next line.

Field

The field is read only.

Operator

Specifies the operator to compose the condition expression.

• =
  Equal to
• >
  Greater than
• >=
  Greater than or equal to
• <
  Less than
• <=
  Less than or equal to
• !=
  Not equal to
• [not] in
  Causes an enumerated list of values to appear in the WHERE clause predicate, used for evaluating for a true condition. For operator "in" or "not in", it is allowed to input multiple values in the Value input box and separate the values with comma (,).
• [not] like
  Like string pattern matching operator is used to compare the first expression string value to the pattern string (the second expression). If you want to use wildcard character in the pattern string, only "_" and "%" are supported.
• [not] between
  Allows the system to evaluate whether or not data values are located between a range of values indicated in the predicate. For operator "between" or "not between", there are two value input boxes for inputting the same type of values.
• is [not] null
  It is used in WHERE clause predicates to match null values occurring in a specified data field. For operator "is null" or "is not null", the value input box is hidden.

Value

Specifies the value of how to build the condition. You can either type in the value manually or select the value from the drop-down list, where the top 50 values of the selected field are listed.

When the field is based on a formula which references a parameter, the value list will be null. Parameters are not supported here.

SQL Statement

Displays the statement expression.

OK

Applies the changes and closes the dialog.

Cancel

Cancels the changes and exits the dialog.

Help

Displays the help document about this feature.

Related topics:

• Adding conditional formats to a DBField
• Binding a link to a label
• Adding conditional formats to shape map areas
• Adding conditional color fill to a chart
• Configuring member-level security