List and rectangle controls in reports
List and rectangle are types of container controls in SSRS. Rectangle control is used for the flow control, while the List data region is a kind of array control. The List region can help in creating very interesting representations of the report. In this recipe, we will discuss the idea of the list and rectangle controls in the process of building a summary sheet for each item group.
How to do it…
Create a new report with the RDP PktItemSalesHistoryDP, and add a new precision design.
In the editor window, insert a list region. Right-click on the control and select the Tablix properties. In the properties window, set the dataset to the RDP dataset ItemSalesHistory.
The Row Groups window, which is at the bottom, must indicate a details row. Click on the arrow at the corner and open Group Properties:
In Group Properties, add a new grouping by ItemGroupId:
Stretch the list data region to fit the entire report. From the toolbox, drag the text box control...
