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.

Field

Specifies the field on which the condition is based.

Operator

Specifies the operator to compose the condition expression.

Value

Specifies the value of how to build the condition.

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.

Field

Specifies the field on which the condition is based.

Operator

Specifies the operator to compose the condition expression.

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.

Field

The field is read only.

Operator

Specifies the operator to compose the condition expression.

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: