CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0- Delete the Visit_Count label that Report Builder put in the Matrix Column field
when we dragged Visit_Count over onto our Matrix. - Drag the PatientStateName field into the Rows field of our Matrix to create a
row grouping for each of the Patients States. Delete the Patient State Name
label that was placed in the top left corner of the Matrix as we did for the Visit
Count label in step 6. Using the Border Lines formatting option, set the lines
around the empty top left corner field to be None. - Insert a Rectangle report object in the Columns field by right-clicking in the
columns field, selecting Insert and then Rectangle. This is where we are going
to put the BranchStateName and a Map for the State. So that we have some
room for our BranchStateName and a Map, make the height of this row to be
about 2 inches as shown in Figure 13-62 shown previously. - Right-click inside of this new Rectangle, select Insert, and then Textbox. Move
the Textbox to the top of the Rectangle and set its width to be 2.5 inches. Right-
click the textbox and select Expression. Set the expression so that it reads
Fields!BranchStateName.Value. Click OK to save the expression. Center the
alignment of the text and make it Bold. Then enter a space after the
[BranchStateName] and then enter Branch. The textbox should now read
[BranchStateName] Branch. - Select a blank section in the Rectangle just below the BranchStateName
textbox that we just created. Using the Home tab on the Ribbon, change the
color of the lines surrounding the rectangle to be Silver and then click on the
border to place lines around the entire rectangle. At this point, our report
should look similar to Figure 13-63.
Figure 13-63. Employee Service Cost by branch and patient state