Previous Topic  Next Topic

Edit Conditions Dialog Box Properties

This topic describes how you can use the Edit Conditions dialog box to add a new condition or edit an existing condition.

Server displays the dialog box when you select the Add button or Edit button in the Conditional Formatting dialog box, or select or in the Insert Link dialog box or Edit Link dialog box if you have selected Conditional Link in the dialog box.

Advanced/Basic

Select to switch between the advanced mode/basic mode.

You see these elements in both modes:

OK

Select to apply any changes you made here and exit the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help button

Select to view information about the dialog box.

Close button

Select to close the dialog box without saving any changes.

Basic Mode

You can create simple filter conditions using the AND/OR logic.

Remove button

Select to delete the current condition line.

Field

Select the field that you want to filter.

Operator

Select the operator to compose the filter expression. See Operator.

Value

Specify the value of how to filter the field. You can either type the value manually in the text box or select a value from the drop-down list. When you type multiple values manually, you should separate them with ",", and if "," or "\" is contained in the values, write it as "\," or "\\".

When you are editing conditional formatting on a field in a crosstab, the button is available. Select the button and you can choose an object from the value drop-down list to use its value in the condition.

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.

Back to top

Advanced Mode

The advanced mode enables the building of more complex filter conditions via the grouping of conditions.

Add Condition

Adds a new condition line.

Delete

Deletes the selected condition line.

Group

Makes the selected conditions in a group. You can add conditions to an existing group by selecting the conditions and the group while holding the Ctrl button, and then selecting 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

Specify 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

Specify the field to be filtered.

Operator

Specify the operator to compose the filter expression.

Value

Specify the value of how to filter the field. You can either type the value manually in the text box or select a value from the drop-down list. When you type multiple values manually, you should separate them with ",", and if "," or "\" is contained in the values, write it as "\," or "\\".

When you are editing conditional formatting on a field in a crosstab, the button is available. Select the button and you can choose an object from the value drop-down list to use its value in the condition.

Condition Expression

Displays the SQL statement of the condition.

Back to top

Previous Topic  Next Topic