Collapse All Expand All

In a fixed page layout, you can group your data on the fixed page. A group set on the fixed page, applies to the entire report including the controls within the report. Therefore, once you set grouping here, you may decide not to group individual data regions.

Use the following steps to understand grouping on a fixed page. These steps assume that you have already added a Page Report template, connected it to a data source and created a dataset. See Adding an ActiveReport to a Project and Connect to a Data Source for further information.

To set grouping on a Fixed Page

1. Right-click the gray area outside the design surface and select Fixed Layout Settings or with the fixed page selected, under the Properties Window, click the Property dialog link to open the FixedPage dialog.
2. On the Grouping page, in the General tab, under Group on enter the field name or expression on which you want to group the data. For example, =Fields!YearReleased.Value.

   Note: A default group name like FixedPage1_Group appears under Name, once you set the group. To modify the group name, add a field name or expression under Group on to enable the Name option and enter a new name.

3. Under the Document map label field, you can optionally set a label to add the item to the document map.
4. Click OK to close the dialog.
5. Drag and drop a data region, like a Table onto the design surface and set data inside its cells.
6. Go to the Preview Tab to view the result. You'll notice that the data appears in groups sorted according the YearReleased field on each report page. 

Support Forum