CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0
- Format the [Sum(Visit_Count)] field to be Number with no decimal places by
selecting the field and then selecting the Properties on the View menu.
Navigate to the Format property under the Number category. Set the format to
be N0 (that is N and zero). Center the field. - Format the [Sum(Estimated_Cost)] field to be Currency with two decimal
places by setting its Format property to C2. - Add a row above the PatientStateName, Visit_Count and Estimated_Cost row
by right-clicking on the PatientStateName field, selecting Insert Row and then
Outside Group – Above. Now that we have these extra fields, let’s put labels in
them to represent the columns that are below them. Set the first empty textbox
to read Patient State, the second to Visit Count, and the last one to Estimated
Cost. Make each of the fields Bold and widen the Patient State column to be
about 1.75 inches wide. Click Run to see the fruits of our labor up to this point.
Set the Service Year parameter to 2009 and click View Report. Figure 13-64
shows what the report should look like if you have been following along.
Figure 13-64. Previewing Employee Service Cost by branch and patient state after outside group and
formatting- As you can see, we have left some space below the branch State names textbox
and the new group. Now we are going to add a Map to that empty space. Click
on the Design button to return to the Report Builder designer. - Right-click in the empty space below the BranchStateName textbox, select
Insert and choose to insert a new Map report object. Report Builder will make
the rectangle much larger, but we will shrink it down after we get the Map just
the way we want it.