Optimize Dataset dialog

This dialog appears when you click the Optimize Dataset button in the Dataset Management 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.

OK

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.

Related topics:

• Optimizing a dataset