To group the results by product name, define groupings.
Procedure
- In the Report Builder dialog box,
click Properties.
- Click the Grouping tab.
- Define the grouping layout.
- In the Group By list, click product_name.
- Select Include Grouping Count.
- Select Include Grouping Value.
- Click Update.