Chapter 4: A Visit to Emerald City: The Report Wizard 185 Figure 4-3 (in the previous Task Notes for SSDT and Visual Studio) shows the dataset used in the Customer-Invoice report. The first 13 rows have a value of Axelburg for the BillingCity column. Therefore, Axelburg appears at the top of Page 1 of the report. All the rows with Axelburg in the BillingCity column will be on Page 1 of the report. You put the Name column in the Row groups area as well. This means the report will create a new group each time the value of the Name column changes. Again, looking at Figure 4-3, you can see the first three rows have a value of Bolimite, Mfg in the Name column. Therefore, these three rows will be combined in the first group on Page 1 of the report. By leaving the Expand/collapse groups check box checked, you told the Report Wizard to create a report in which the detail lines for each grouping are initially hidden. The detail lines for a group become visible when the plus sign for that group is clicked. However, we only want the lowest-level group (the Details group) to be initially hidden. We do not want the Name group to be initially hidden. This is why we used the Group Properties dialog box to change the initial value of this group from Hide to Show. By leaving the Show subtotals and grand totals check box checked, you told the Report Wizard to total any numeric columns in the detail and to show those totals in the group footer for each group.