A script-enabled browser is required for this page to function properly.

About groups

Groups are created to organize the columns in your report.   Groups can do two things: separate a query’s data into sets, and filter a query’s data.

When you create a query, Reports Builder automatically creates a group that contains the columns selected by the query. You create additional groups to produce break levels in the report, either manually in the Data Model view or by using the Report Wizard to create a group above or group left report.

Create groups when you want to treat some columns differently than others. For example, you create groups to:

With the exception of cross-product groups, all user-created groups are called break groups.

Break groups

You create break groups to produce subtotals, print columns in a different direction, create breaks, and so on. A break group suppresses duplicate values in sequential records. For example, Reports Builder can select the department number for each record; however, the duplicate department numbers are not printed.

Cross-product groups

You create cross-product groups to perform mathematical cross products, which are generally used to create matrix reports.

Group filters

Filters enable you to conditionally remove records selected by your queries. Groups can have two types of filters:

See also

About links versus groups

About group filters

About group above reports

About group left reports

About matrix with group reports

Creating a multiquery group above report

Creating a report

Creating a break group

Creating a matrix (cross-product) group