• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Grouping Records

When you create a report with the Report Wizard, you can choose to group like records together to obtain subtotals and other calculations for each group. For example, in a report of sales representative sales figures for a year, you might group the representatives' sales by month. In this way, you can easily determine who was the top achiever each month. In another report, you could group all the sales representatives' results together to see trends for the representatives' performance over a whole year. Even if you create your report from scratch or decide to group records later, you can use the Sorting And Grouping feature to further organize information in your report.

Group Records

In Design view, click the Sorting And Grouping button on the Report Design toolbar.

Click the Field/Expression box, and then click the list arrow that appears. Choose a field for grouping records, or type an expression.

Click the corresponding Sort Order box, click the list arrow that appears, and then click Ascending or Descending, depending on what sort order you want to use.

Select the Group Properties settings you want to use.

Repeat steps 2 through 4 for each Field/Expression you want to create to group and sort your data.

When you're done, click the Close button.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint