Previous Page Next Page

Manage Datasets

This dialog appears when you click Report > Manage Datasets. It helps you to manage the datasets created for the open library component or page report that is created using query resources.

The following are details about options in this dialog:

Dataset List

Lists all the datasets that you created for the open report.

• Name
  Shows the name of the dataset. You can click 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.

New

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.

Remove

Removes the specified dataset from the report. You cannot remove a dataset that is being used by any data component.

Optimize Dataset

Optimizes the selected dataset. Available only when managing datasets in a page report created using query resources.

Data tab

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 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 Resources box.
• 
  Moves the selected field one step up.
• 
  Moves the selected field one step down.

Filter tab

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:

• Filter
  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.

OK

Applies the changes and closes the dialog.

Cancel

Cancels the changes and exits the dialog.

Apply

Applies the changes and leaves the dialog open.

Help

Displays the help document about this feature.

Previous Page Next Page