Data Grouping Tab, Report Properties Dialog Box (Report Builder)

Allows you to specify nested regions of the layout that are rendered only when an expression changes its value.

This tab is pre-selected when you choose Data Grouping from the Report menu or the report layout context menu.

This tab also appears on the Properties dialog box of Detail bands.


This tab replaces the functionality of the native Visual FoxPro Data Grouping Dialog Box when the Report Builder is active.

Group nesting order

Lists the expressions that determine breaks between data groups. The mover button allows you to change the nesting order of the group expressions.


Adds a new data group expression to the Group nesting order list.


Deletes the selected data group expression from the Group nesting order list.

Group on

Displays the data group expression selected in the Group nesting order list. Empty expressions are not valid.

You can type or build an expression by clicking the ellipsis (…) button. For more information, see Expression Builder Dialog Box.

Group starts on

Specifies where the grouped bands' information will be rendered when the group expression value changes.

New line

Specifies that the group will start immediately on the next line of the output.

New column

Specifies that the group expression change will force the information to be rendered as a new column. Available only when the page layout contains more than one column.

New page

Specifies that the group expression change will force the information to be rendered as a new page.

New page number 1

Starts a new page and restarts page numbering every time the data group expression value changes.

Reprint group header on each page

Specifies that the group header follows the page header on all pages for the data group when the data group spans more than one page.

Start group on new page when less than

Specifies the minimum distance from the bottom of the page that determines when to begin the group header on the next page.


Use this option to prevent a "orphaned" group header, and potentially inappropriate data, at the end of a page with no accompanying detail information. An orphaned group header may display data from a record not shown elsewhere on the page, since the page footer will display information appropriate to the previous group.

See Also

© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic