Dataset Editor dialog

This dialog appears when you check the Existing radio button, select an existing dataset and click the Modify button in the Data screen of the report wizard. It helps you to edit the selected dataset and consists of the following tabs:

OK

Applies the changes and closes the dialog.

Cancel

Cancels the changes and exits the dialog.

Help

Displays the help document about this feature.

Data tab

Adds some extra data fields to the dataset or removes some existing data fields from the dataset. See the tab.

Available Resource

Lists all the available data fields contained in the data source on which the dataset is created.

Dataset

Lists all the fields that are included in the dataset.

Moves the select data field up a step.

Moves the select data field down a step.

Adds the select data field to the dataset.

Removes the select data field from the dataset. Only the fields which are not used by any data component created on the dataset, either directly or indirectly, can be removed.

Removes all the data fields from the dataset. When you click the button, only the unused data fields will be removed actually. When you enter the dialog the next time, you will find that the data fields used by data components created on the dataset will still display in the Dataset box.

Filter tab

Sets some conditions to filter the data of the dataset. See the tab.

Add Condition

Adds a new condition line.

Delete

Deletes the selected condition line.

Group

Makes the selected conditions in one 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 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 to be filtered.

Operator

Specifies the operator to compose the filter expression.

Value

Specifies the value of how to filter the field. You can either type in the value manually or click next to the text box to specify the value.

When you type in the value, if multiple values are required, they should be separated with ",", and if "," or "\" is contained in the values, write it as "\," or "\\".

When you click to specify the value, the Expressions dialog is displayed. The following are options in the dialog:

SQL Statement

Displays the SQL statement of the filter condition.

Related topics: