Report Studio

You can perform more advanced groupings in a list to get the results you want. For example, you can:

• view the entire grouping structure and make changes to the grouping order
• group a data item that appears in a query but not in the layout
• specify a list of properties for a group

You can also perform advanced sorting.

To Perform Advanced Grouping:

1. Click a column in the list.
2. Click the select ancestor button in the title bar of the Properties pane and click List.
3. In the Properties pane, double-click the Grouping & Sorting property.
4. If you want to change the grouping order, in the Groups pane, click the grouped item that you want in the Groups folder and drag to the location that you want in the grouping hierarchy.
5. If you want to create a new grouping, in the Data Items pane, click the data item that you want and drag it to the Groups folder in the Groups pane.
6. If you want to specify a list of properties for a group, do the following:

• Click the group that you want.
  
  Note: Click Overall to specify a list of properties for the overall group. The overall group is the grouping of all data into one group. You can specify a list of properties for the overall group to add overall totals to the list.
• Click the properties button .
• Select the appropriate check boxes.
• Click OK.

7. Click OK.

Related Topics:

• Grouping Data—Grouping data in Report Studio.
• Set the Group Span for a Column—How to change the group span for a column.
• Setting List Properties—How to set list properties in Report Studio.

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved