Use groups to organize data in a banded list. There are several ways to do this, and you can use detail grouping as well.

To group a banded list

1. Right-click the BandedList data region and select Insert Group.
2. In the Groups smart panel that appears, under Group on enter an expression by which to group the data. The following is an example using the Reels database movie rating field in the movie table. 

   =Fields!MPAA.Value

   Note: The name for the group is disabled until after you enter the Group on expression.

3. Click the Accept button to accept the change.
   

Or

1. Right-click the BandedList data region and choose Properties.
2. In the smart panel that appears, select the Groups page and click the Add button.
   
3. Under Group on enter an expression by which to group the data. The following is an example using the Reels database movie rating field in the movie table. 

   =Fields!MPAA.Value

   Note: The name for the group is disabled until after you enter the Group on expression.

4. Click the Accept button to accept the change.
   

Optional grouping settings

• Under Document map label you can set a label to add the item to the document map (table of contents).
• Under Parent group you can set the parent group for a recursive hierarchy.  See Grouping and Sorting Data for more information.
• You can also select the following options on this page:
  • Page break at start (begins the group on a new page)
  • Page break at end (begins a new page after the group)
  • Include group header (selected by default)
  • Include group footer (selected by default)
  • Repeat group header (repeats the group header on a new page when necessary)
  • Repeat group footer (repeats the group footer on a new page when necessary)

There are also other pages that allow you to further control each group. The icons for these pages are just below the list of groups.

• On the Filters page, you can set expressions and operators and values to filter the data. See Filtering a List or Banded List Group for more information.
  
• On the Sorting page, you can sort the data by fields in expressions. See Sorting a Banded List for more information.
  
• On the Visibility page, you can optionally change the initial visibility of the group. See Toggling Visibility for more information.
  
• On the Data Output page, you can optionally control how data is exported to XML.
  

See Also