Add a Grouping:
A dataset result in Visual Studio Report Designer is flattened data.
This means the Salesperson/Purchaser table and the Customer
table are joined.
In the Visual Studio Report Designer, the hierarchy is defined in
each control, in this case, the table control. The following steps show
how to add the grouping of customers by their salesperson.
a. In the Properties window, select the Table properties and set the
property DataSetName to DataSet_Result. This connects the table
to the dataset. When you add a field from the dataset to the
table, the table is automatically connected to the dataset. In this
example, a group is created in a table that does not contain fields
from the dataset.
b. In the Grouping panel at the bottom of the page, click the Row
Group arrow and click Add Group > Parent Group. See the
”Add Parent Group to Table” figure.