Optimize Dataset Dialog

The Optimize Dataset dialog appears when you select the Optimize Dataset button in the Manage Datasets dialog. It helps you to optimize the selected dataset. See the dialog.

The following are details about options in this dialog:

Data retrieved for the dataset

Specifies the method used to retrieve data at runtime.

Only Columns Used in Report
If checked, only data columns used in the current report are retrieved at runtime. This way ensures the best performance since the least data is involved in.
All Columns in Dataset
If checked, all data columns defined in the dataset are retrieved at runtime.
All Columns in Query
If checked, all data columns in the query that the dataset is based on are retrieved at runtime. The performance of this way is not as good as the other two.

Applies the settings and closes the dialog.

Cancel

Does not retain the changes and closes the dialog.

Help

Displays the help document about this feature.