Select N dialog

This dialog appears when you click the Select N button in the Group screen of the banded/table wizard, or in the Display screen of the map wizard. It helps you to specify a number to filter groups to be displayed in the report, or a parameter which returns an integer to filter group dynamically when previewing the report. 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 the help document about this feature.

Related topics:

• Specifying the Select N condition