CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0Figure 13-35. Changing the number formatting
To address the empty columns, add a filter to the report to limit the data to only discharged patients
with discharge reasons and to patients who have a marital status defined. The Filter button on the
toolbar will launch the Filter Data dialog box. In Figure 13-36, you can see that you can add four filter
conditions: where MaritalStatusID, Discharge Date, and Discharge Reason are not empty and where the
Discharge Year is greater than or equal to 2010. (We added the last filter to demonstrate that it is possible
to have the report prompt the user for a value as a parameter that is tied to a filter.) To change the
comparison operator from the default of equal to not empty, click on empty and select both Not and Is
Empty from the available operators. For the Discharge year, select the Greater Than or Equal To
operator. After you set the year to be 2010, click on the Discharge Year label and select Prompt to set it as
a report parameter as depicted by the green question mark icon shown next to the Discharge Year filter
label.