Share via


Data Grouping Dialog Box

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

Note

Depending on the setting of the _REPORTBUILDER system variable, this dialog may be replaced by an alternative user interface. For more information, see _REPORTBUILDER System Variable.

How to: Add Data Groups to Reports

Group expressions

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

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

Group properties

Specifies output options for data groups.

  • Start group on 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.

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

  • Reset page number to 1 for each group
    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 follow 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.

    Tip

    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.

  • Insert
    Inserts a blank text box in the Group expressions box so you can type a new group expression.

  • Delete
    Deletes the selected group expression from the Group expressions box.

See Also

Other Resources

Working with Report Data Groups

Dialog Boxes (Visual FoxPro)