Previous Topic
Select N Dialog
The Select N dialog 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. It appears when you select the Select N button in the Group screen of the banded/table wizard, or in the Display screen of the map wizard.
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 N
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 N
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.