CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0dialog box that the Pat ID field, when added to the Formula textbox, has a dotted line beneath it
indicating a link. You can click the field and add a filter while defining the formula for the new field,
which you will do next.
Figure 13-39. Defining a formula for a new field, Patient Count
Click the No Filter Applied link, and select Create a New Filter to open the Filter Data dialog box.
You can see the filter you need to apply to show only active patients in Figure 13-40, where you have set
Discharge Date to “empty,” which will force only patients who do not have discharge dates to be used in
the formula. To implement the filter, drag Discharge Date over into the filter pane. Then select the Is
Empty value by clicking on the equals link label. Call the filter Active Patients, and click OK. Once the
Patient Count field is created and shows up on the Fields tab, you can drag and drop it in the Data value
fields area of the chart. In this case, since we are adding it to the Data value fields area, we could simply
double-click on the Patient Count field and Report Builder will place it in the correct section.