Pro SQL Server 2012 Reporting Services

CHAPTER 4  LAYING OUT A REPORT

Figure 4-4. Previewed report with duplicate patient

In SSRS 2005, you would have had to add two Lists, one nested in the other, to produce output that

would allow for multiple groupings in one container object. We showed that approach in the previous

edition of this book. However, with the introduction of Tablix properties, we can simply add another

grouping above Employee_Name. To do this, right-click the details row of the List box where we added the

fields, and select Add Group; then Parent Group under the Row Group submenu, as shown in Figure 4-5.

For the group, select Patient_Name as the expression. You will notice that a new column is added for your

new Patient_Name group. Select the Patient_Name textbox that we added earlier and delete it from the

details section.