Define attribute grouping if you want the report results
to be grouped.
Procedure
- In the Report Builder dialog box,
click Properties.
- Click the Grouping tab.
- Define the grouping layout.
- 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.
- To show the number of items in the group on the report,
select Include Grouping Count.
- To show the attribute used to group the results on the
report, select Include Grouping Value.
- Optionally, select or create charts for the group.
Select one or more charts, or add a chart by performing the
following steps:
- 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.
- In Title, select the _New_Chart string,
and then type the chart name.
- In the Attribute list, click
the attribute to chart.
- In the Second Attribute list,
click the attribute to chart, if required.
- In Width in Pixels, type the
graphic width, or accept the default value.
- In Height in Pixels, type the
graphic height, or accept the default value.
- Click Update.
The
chart title is displayed in the Charts Included On Grouping
Template list.
- Optionally, define grouping metric operations.
- In the Metric Operations section, click Add.
The Available Metric Operations Definition subdialog
box opens.
- In the Select a Metric Type list,
click Column or Row and Column.
- In the Select a Metric Operation list,
click a metric operation.
The XXX Metric area is displayed
under Available Metric Operations.
- Define the metric.
- In the metrics definition area, click Create.
- Under Layout, click Update.