You can use the Dataset Editor dialog box to edit the selected dataset. This topic describes the options in the dialog box.
Designer displays the Dataset Editor dialog box when you select More Options, then select Existing Dataset, select an existing dataset and select Edit in the Data screen of the component wizard while creating a data component using a query resource in a page report.
The dialog box contains the following tabs:
You see these buttons in the tabs:
Select to apply your settings and close the dialog box.
Select to close the dialog box without saving any changes.
Select to view information about the dialog box.
Use this tab to add extra data fields to the dataset or remove existing data fields from the dataset.
This box lists all the DBFields in the query resource on which the dataset is created, and the parameters and valid formulas of these DBFields in the same catalog data source as the query resource, which you can add to the dataset.
This box lists all the fields that you specify to include in the dataset.
Select to add the specified data field in the Available Resources box to include in the dataset.
Select to remove the specified data field from the dataset. You can only remove the fields that are not used by any data component created on the dataset, either directly or indirectly.
Remove All button
Select to remove all the data fields from the dataset. When you select this button, Designer only removes the unused data fields actually. When you open the dialog box the next time, you can see that the data fields used by data components created on the dataset still display in the Dataset Resources box.
Move Up button
Select to move the specified data field higher in the display order.
Move Down button
Select to move the specified data field lower in the display order.
Use this tab to specify conditions to filter the dataset.
Designer displays the same options in the tab as in the Dataset Filter dialog box.