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

Chapter 6 Understanding Parameter Sets
84 Rockwell Automation Publication RPTEXP-UM001H-EN-P-June 2014
• A grouping type list (page 85).
• A grouping expansion type icon (page 87).
• A removal icon (page 88).
When you create a grouping filter, you must specify the field that
will be used to group the information and the grouping type.
The maximum number of fields/groups available is:
• 5 group fields
• 3 row groups
• 2 column groups
• 1 page group.
NOTE
The Event Detail, Event Detail Paged, Root Cause Analysis, and
State Detail reports do not respond to user groupings. However,
the Root Cause Analysis and State Detail reports have one
hard-coded grouping with one page group (line) and four row
groups (Work Cell, Shift Start, State, and PartId).
Data aggregation for each grouping is done sequentially (1 through
5). When groupings are in the parameter set, aggregations are done
for:
1. 0 groupings (grand totals)
2. Grouping 1
3. Grouping 1, 2
4. Grouping 1, 2, 3...
5. Etc.
An aggregation is not done for grouping 1, 3, or just grouping 3.
This is not a concern until you mix row and column groupings.
when there is a mix, you can expand group 3 before you expand
group 2.