Defining attribute grouping

Define attribute grouping if you want the report results to be grouped.

Procedure

  1. In the Report Builder dialog box, click Properties.
  2. Click the Grouping tab.
  3. Define the grouping layout.
    1. In the Group By list, click the attribute by which to group. For example, if you query for CRs and group using the product_name attribute, CRs with the same product name are grouped on the report.
    2. To show the number of items in the group on the report, select Include Grouping Count.
    3. To show the attribute used to group the results on the report, select Include Grouping Value.
  4. Optionally, select or create charts for the group.

    Select one or more charts, or add a chart by performing the following steps:

    1. Under Charts Included on Grouping Template, click Add.

      The Grouping Chart Layout subdialog box opens.

      The temporary chart name, _New_Chart, is displayed in the Charts Included in Report subdialog box.

    2. In Title, select the _New_Chart string, and then type the chart name.
    3. In the Attribute list, click the attribute to chart.
    4. In the Second Attribute list, click the attribute to chart, if required.
    5. In Width in Pixels, type the graphic width, or accept the default value.
    6. In Height in Pixels, type the graphic height, or accept the default value.
    7. Click Update.

      The chart title is displayed in the Charts Included On Grouping Template list.

  5. Optionally, define grouping metric operations.
    1. In the Metric Operations section, click Add.

      The Available Metric Operations Definition subdialog box opens.

    2. In the Select a Metric Type list, click Column or Row and Column.
    3. In the Select a Metric Operation list, click a metric operation.

      The XXX Metric area is displayed under Available Metric Operations.

    4. Define the metric.
    5. In the metrics definition area, click Create.
  6. Under Layout, click Update.

Example

Defining groupings: example

Feedback