CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0Figure 13-23. Table report template in Report Builder 1.0
Creating a Table Report
To address many of the report requests received from user feedback, you can use the table report. One
item to note, which may fall into the category of a limitation of Report Builder 1.0, is that you can use
only one data region per report. In other words, unlike the full IDE of BIDS, users who build reports with
Report Builder 1.0 are limited to one Table, Matrix, or Chart data region per report. You cannot add a
second data region. In fact, reports are not only limited to a single data region, but they are relegated to
using the controls that have been defined for each template. It is not possible to add textboxes, for
example, or any other type of design element, other than the data from the fields. You will work within
this limitation to produce your first report, a patient face sheet (as it is commonly called), which displays
demographic information about each patient. With the table report still open, you will drag several fields
onto the table where it says Drop Column Fields so that the report looks like Figure 13-24. Next, hold the
CTRL key down on the keyboard while selecting Pat ID, Pat First Name, Pat Last Name, Diagnosis, Start
Of Care, Address 1, City, State, and Zip. After you have them all selected, drag them to the right of Pat ID
in the table of the report. By holding the CTRL key, as we’ve done here, we create a group of Patient
Census column names. At this point, you can also add a title in the Click to Add Title textbox. Change the
title to Patient Face Sheet and make it bold. Notice also that as the fields are added, Pat Last Name, for
example, they become bold in the Fields tab on the left indicating they have already been used.