CHAPTER 6 BUILDING REPORTS- Right click on the (Details) group in the Row Group pane and select Group
Properties. Click Add under Group Expressions and select [Employee_Name]
in the Group On drop-down list. - To give our report a clean stepped look, right click on the Employee_Name
field in the table, select Insert Row and then Outside Group –as shown in
Figure 6-4. Next, drag the Patient_Name field that was added in step 5 into the
new empty cell above Employee_Name. Right click on Patient_Name and then
do the same thing by selecting Insert Row and then Outside Group – Above.
This time, drag the Service_Type that was added in step 5 into the new empty
space. With two of our groupings down, let’s do the same thing for the next
level up in our hierarchy. Right click on Service_Type and Outside Group –
Above. This time, drag our Diagnosis field above the Service_Type. Figure 6-5
shows what our report should look like in the designer.
Figure 6-4. Employee Service Cost report Add Outside Group – Above for stepped look
- Now, remove the three columns with headers that read Diagnosis, Service
Type, and Patient Name by right clicking each of them and choosing Delete
Columns. After you remove the three columns, drag your Tablix closer to the
left side of the Design pane. Then make the column labeled Employee Name
about three inches wide so that the values don’t end up wrapping to the next
line.