Pro SQL Server 2012 Reporting Services

CHAPTER 13  CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0

Figure 13-26. Define Formula window

Now that you have the patient’s full name combined, you can delete the Pat Last Name field by

clicking the data cell and pressing the Delete key. A couple of other tasks remain before previewing the

report. The first one is to move the Zip column to the right of the State column. To do this, just click on

the cell containing Zip and drag it to the right of the State column. Next, let’s resize the fields so that

each record will fit on a single line. Of the fields you have used for the report, the Diagnosis and Address

fields have the potential to be the largest, as they are variable-length fields that usually contain between

20 and 50 characters. However, since we want the headers for each column to be on one row, we will also

resize Start of Care. For this example, size the Pat ID field to about .5 inches, expand the Diagnosis, Start

of Care, and Address 1fields to approximately 1.5 inches, and preview the report, as shown in Figure

13-27. There will be as many x characters representing the data as there are characters found in the

largest value in the database field, which makes it easy to determine how much to resize each column.

The reason that the Address fields display NA is because this information was either scrambled, in the

case of the patient names, or modified to be NA to remove identifiable information. Notice also, in

Figure 13-27, that each field automatically contains an interactive sorting icon at the column heading

level. Though clicking the icon will re-render the report, no actual sorting will be performed until you

configure it to do so. You will do that next.