Pro SQL Server 2012 Reporting Services

CHAPTER 4  LAYING OUT A REPORT

As you did with the List, you will begin on the Design tab and double-click the Table in the Toolbox.

This adds a Table to the report design area. Next, drag the same fields you used for the list example to the

detail row of the table—Employee_Name, Service_Type, Estimated_Cost, and Visit_Count as detail

information and Patient_Name for the group. To add the first four fields to the detail row, you need to add

a fourth column to the Table. You accomplish this by right-clicking the bar at the top of the middle

column and selecting Insert Column to the Right. You now have four equally sized columns to which you

can drag the four fields so that the report appears as it does in Figure 4-13, with the fields placed in the

detail row of the Table. You will wait to add the Patient_Name field until you add a grouping level. Notice

that the column headings for each of the fields are added automatically when the fields are dropped into

the individual cells.

Figure 4-13. Table data region with detail rows

To add the Patient_Name field to the Table so that the report has the same functionality as the list

you created previously, you need to insert a group in the Table. To do this, simply drag the Patient_Name

field in the emp_svc_cost dataset down into the Row Groups section and release it just above the

(Details) row group as shown in Figure 4-14 below.