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.

Note

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

• How to: Add Data Groups to Reports

• How to: Edit Data Groups in Reports

• How to: Configure Output for Data Groups

• How to: Delete Data Groups in Reports

• 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.

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

• Remove
  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.

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.

See Also

Reference

Report Properties Dialog Box (Report Builder)

Other Resources

Working with Report Data Groups