CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0Figure 13-27. Previewing the Patient Face Sheet report
Return to the design area of the report by clicking the Design Report button on the toolbar. Next,
right-click the Pat ID data cell, and then select Sort and Group on the toolbar. This will open the Sort
dialog box. With the Patient Census group selected, choose to first sort by Pat ID, then by Patient Name,
and finally by Diagnosis, as shown in Figure 13-28. You also have the ability to put a page break after
each group as a group option. Do not add a page break at this time. Once you click OK, you can preview
the report and see that the sorting for each of the defined columns is working correctly.