Manage Datasets Dialog
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.
- 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.
Removes the specified dataset from the report. You cannot remove a dataset that is being used by any data component.
Opens the Optimize Dataset dialog to optimize the selected dataset. Available only when managing datasets in a page report.
Modifies fields in the selected dataset.
- Available Resource box
Lists all the resources that can be added to the dataset.
For a dataset created on data resource such as query, stored procedure, imported SQL, UDS, and HDS, it lists all the DBFields in the data resource, as well as parameters and valid formulas in the catalog data source where the data resource is added.
For a dataset created on a business view, it lists all the view elements and the dynamic resources created in the report.
- Dataset 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 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.
Moves the specified field one step up.
Moves the specified field one step down.
Sets filter conditions for data in 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 data resource such as query, stored procedure, imported SQL, UDS, and HDS, 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.