Manage Datasets Dialog
The Manage Datasets dialog helps you to manage the datasets created for the open library component or page report that is created using query resources. It appears when you select Report > Manage Datasets.
The following are details about options in this dialog:
Lists all the datasets that you created for the open report.
Shows the name of the dataset. You can select in the text box to edit the name.
- Data Source
Shows the data source in which the dataset is located.
- Query/Business View
Shows the data resource that the dataset is based on.
Opens the New Dataset dialog to add a new dataset to the report. Available only when managing datasets in a page report created using query resources.
Removes the specified dataset from the report. You cannot remove a dataset that is being used by any data component.
Optimizes the selected dataset. Available only when managing datasets in a page report created using query resources.
Modifies fields in the selected dataset.
- Available Resources box
Lists all the resources that can be added to the dataset.
For a dataset created on a query resource, it lists all the DBFields in the data resource, as well as parameters and valid formulas of these DBFields in the same catalog data source as the data resource.
For a dataset created on a business view, it lists all the view elements and the dynamic resources created for the business view in the report.
- Dataset Resources box
Lists the fields that are added to the dataset.
Adds the selected fields to the dataset.
Removes the selected fields 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.
Remove all the data fields from the dataset. When you select the button, only the unused data fields will be removed actually. When you open 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 Resources box.
Moves the selected field one step up.
Moves the selected field one step down.
Sets filter conditions for the selected dataset.
The tab varies based on the data resource on which the selected dataset is created.
If the dataset is created on a query resource, the options in the tab as the same as those in the Dataset Filter dialog.
If the dataset is created on a business view, the options in the tab are as follows:
Lists all the predefined filters of the business view on which the dataset is created. Select one from the drop-down list to apply, or select User Defined and define a new filter according to your requirements.
- The other options in the tab as the same as those in the Condition panel of the Predefined Filter dialog.
Applies the changes and closes the dialog.
Cancels the changes and exits the dialog.
Applies the changes and leaves the dialog open.
Displays the help document about this feature.