CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0
Figure 13-28. Sorting and grouping optionsWe should mention one more thing about dragging fields to the table area of the report: groups are
automatically defined from left to right. In other words, dragging and dropping fields to the right of
another field keeps the field in the same group, in this case the Patient Census group; however, if you
have already dragged a field to the table and then drag another one to the left of it, another group is
created based on the name of the field that is dropped. You can see this in Figure 13-29, where if you
were to drag the Branch Name field to the left of the Pat ID field. If you are going through these steps, go
ahead and drag the Branch Name field to the report to see the automatic grouping. Also, go ahead and
resize the table header row to have a height of one line. Then drag the entire table to be a little closer to
the title. Performing these steps should result in a report similar to that shown in Figure 13-29.