O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a row group

Grouping data in a report adds readability to your overall design. But, be aware of the negative impact of adding groups in the performance of your report.

  1. Right-click on the first column (Date), and navigate to Add Group | Parent Group (under Row Group) as shown in the following screenshot:
    Creating a row group
  2. That displays the Tablix group dialog box. From the Group by drop-down list, let's select [Product] because that is how we want to group our data—by Product. Also, select the Add group header checkbox, which will add an extra row that we can use to display aggregates for each Product group:

A new column now appears in the first position of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required