Rockwell Automation FactoryTalk Report Expert User Guide - Manual (Page 85)

Understanding Parameter Sets Chapter 6
Rockwell Automation Publication RPTEXP-UM001H-EN-P-June 2014 85
For example, you might group the Performance report by Work
Cell, Shift, and Part. This allows you to see OEE for everything,
OEE for each work cell, OEE for each shift for each work cell, and
OEE for each part within each shift for each work cell. This would
not allow you to see OEE for each part for each work cell. To do
that, you would have to order the grouping by Work Cell, Part, and
then Shift.
Use the grouping field to organize and label the information in a
report. For example, if you select Work Cell as a grouping field and
you have Bend, Cut, Finish, Machine, and Weld work cells, your
report will contain rows, columns, or pages (subsections) labeled
with those work cell names and containing data associated with
those work cells. There is a maximum of five grouping fields.
NOTE
Do not select the same grouping field twice. If you select two identical
grouping fields and then attempt to view the report, the message
Duplicate grouping field found. Please set correct grouping
parameters. will appear.
Use the grouping type to specify the general layout of the
information in a report.
You can group fields by row, column, and page.
• Grouping by rows
When you specify the row grouping type, the grouping field is
added to the report as a column and the grouped information
is organized in rows. For example, if you group a Performance
report by work cell and select a group type of row, the
information in your report will look something like this:
Selecting the Grouping Field
Selecting the Grouping Type