## Select N dialog

This dialog helps you to specify a number to filter groups which to be displayed in the report, or a parameter which returns an integer to filter group dynamically when previewing a report.

If this dialog is opened by clicking the Select N button in the Group screen of the banded/table report wizard, options in the dialog are shown as below. See the dialog.

The following are details about options in the dialog:

In

Indicates where the Select N condition will be applied.

Select N

Specifies the Select N condition to define groups that will be displayed while others are hidden.

- All
  If selected, all groups in the report will be displayed.
- Top
  If selected, specify a number in the field below and the first N groups in the report will be displayed. You can also select a parameter from the drop-down list, which returns an integer, and then specify a value for the parameter when viewing the report to dynamically define the Top N condition.
- Bottom
  If selected, specify a number in the field below and the last N groups in the report will be displayed. You can also select a parameter from the drop-down list which returns an integer, and then specify a value for the parameter when viewing the report to dynamically define the Bottom N condition.

Other

If checked, all the other records that don't match the Select N condition will be displayed (which are by default hidden) in another group. Specify a name for this group as required.

This option is available only when the Select N condition is applied to a certain group.

OK

Accepts the changes and closes the dialog.

Cancel

Discards the changes and closes the dialog.

Help

Displays this help document.

If this dialog is opened by clicking the Select N button in the Display screen of the chart report wizard, options in the dialog are shown as below. See the dialog.

Select N

Specifies the Select N condition to define the number of category/series values that will be displayed while others are hidden.

- All
  If selected, all category/series values in the chart will be displayed.
- Top
  If selected, specify a number in the combo box to the right and the first N category/series values in the chart will be displayed. You can also select a parameter from the list, which returns an integer, and then specify a value for the parameter when viewing the report to dynamically define the Top N condition.
- Bottom
  If selected, specify a number in the combo box to the right and the last N category/series values in the chart will be displayed. You can also select a parameter from the list which returns an integer, and then specify a value for the parameter when viewing the report to dynamically define the Bottom N condition.

Based on

If checked, the category/series values will be sorted by the values of the summary selected with the direction specified. If uncheck, the category/series values will be sorted by themselves.

Other

Enabled only when Top or Bottom is selected from the Select N drop-down list. Check this option and then type a character string in the text box to group all the category/series values beyond the top/bottom N category/series values.

OK

Accepts the changes and closes the dialog.

Cancel

Discards the changes and closes the dialog.

Help

Displays this help document.

###### Related topics:

- Specifying the Select N condition
- Defining the Select N condition in a chart