If you like to sort and group, open the Report Builder view, then open the Sorting and Grouping dialogue box. Select to show a Group Header for the fields that you want to group, and select to hide the Group Header for the fields that you want to be sorted. Close the Sorting and Grouping window and execute the report.
如果您想要排序和组合，打开“报表构建器”视图，然后打开“排序和组合”对话框。选择显示要组合字段的组合页眉，并且选择隐藏要排序字段的组合页眉。关闭“排序和组合”窗口并执行此报表。