# data[].attributes.body
On the CREATE tab, in the Reports group, click the Labels button. The first Label Wizard dialog box appears. Click the Modify the label design option button and click Finish

On the HOME tab, in the Views group, click the lower half of the View button and select Print Preview from the menu. You should see a page of labels on the screen. Click the Print button. The Print dialog box appears. Click OK to print or click Cancel to close the dialog box.

# data[].attributes.body
Navigation Pane and select Copy from the shortcut menu that appears. 2. Right-click in a blank area in the Navigation Pane and select Paste from the menu. The Paste As dialog box appears. 3. In the Paste As dialog box, replace the name of the report in the Report Name field by key and click OK

4. Open the Sales by Salesperson report in Design view. You want to remove the subform from the report and keep only the sales relate

. On the HOME tab, in the Views group, click the lower half of the View button and select Print Preview from the menu. Notice the large area of blank space between company names in the detail section.

# data[].attributes.headline
Step By Step:  Create a Subform on  a Report

# data[].attributes.subject
Step By Step:  Create a Subform on  a Report

# data[].attributes.body
1. Switch to Design view. 2. Click and drag the Future Period Contract Projections form object from the Navigation Pane to the Report Detail section under the Company Name and Contract Amount controls

3. Switch to Report View to view the Report and related subform, and cycle through the two records in the top subform using the record navigation buttons on the subform.

# data[].attributes.body
1. Switch to Layout view. 2. Click the Group On Sales Person Last Name row and click More. 3. Click the with no totals down arrow

4. Click the Total On menu down arrow and select Contract Amount. 5. Click the Type menu down arrow and select Sum if it isn’t selected already. 6. Click the Show Grand Total box. The menu disappears and the grand total appears in the Contract Amount column at the bottom of the report. 7. Click the Group On Sales Person Last Name row again and click More, then click the with Contract Amount totaled down arrow. 8. Click the Total On menu down arrow and select Contract Amount, then click the Show subtotal in group footer box. The settings are applied, and the subtotals are now shown in each group’s footer. 9. Select the Sales Person Last Name field header on the report. 10. On the DESIGN tab, in the Grouping & Totals group, click the Totals button and select Count Records from the menu. 11. Switch to Report view. The total number of records appears at the bottom of the report

# data[].attributes.headline
Step By Step; Change Grouping Options Part 2 

# data[].attributes.subject
Step By Step; Change Grouping Options Part 2 

# data[].attributes.body
Switch to Layout view.

Click the Group On Sales Person Last Name row in the Group, Sort, and Total pane and then click the More button to view the available grouping options

Click the down arrow beside with a header section and select without a header section from the drop-down menu

4. Switch to Design view. Notice that the Sales Person Last Name Header has been deleted from the grouping area. 5. Switch to Layout view. 6. Click the down arrow beside the without a header section (if the without a header section option doesn’t appear, click the More button) and select with a header section from the drop-down menu. 7. Click the Move up arrow at the end of the Group On Sales Person Last Name row. Notice that the Sales Person Last Name group is now the top level group in the report. 8. Click the Add a group button and select Company Name from the menu. A new group level is added to the report. 9. On the DESIGN tab, in the Grouping & Totals group, click the Hide Details button. The data in the Contract Amount field is hidden. 10. On the DESIGN tab, in the Grouping & Totals group, click the Hide Details button. The data in the Contract Amount field is displayed. 11. Click the More button in the Group, Sort, and Total pane. 12. Click the with A o n t op down arrow on the Group On Company Name row in the Group, Sort, and Total Pane and select with Z on top from the drop-down menu. The sort order is changed from ascending to descending order. 13. Click the with Z on top down arrow and select with A on top. 14. Click the Delete button on the right side of the Group On Company Name row in the Group, Sort, and Total pane. The row is deleted, as is the Company Name header section. 15. Switch to Report view to see the report.

# data[].attributes.headline
Step By Step: Change Group Options Part 1

# data[].attributes.subject
Step By Step: Change Group Options Part 1

# data[].attributes.body
Grouping options include:

Sort order: Choose ascending or descending

Group interval: Change the way records are grouped together

Totals: Add totals to fields

Title: Change the label of a column heading or summary field

With/without header: Add or remove the header section

With/without footer: Add or remove footer section

Do not keep group together on one page: Groups can be broken up by page breaks

Keep whole group together on one page: Minimizes the number of page breaks in a group on one page

Keep header and first record together on one page: Makes sure a group header is not printed by itself at the bottom of a page

# data[].attributes.headline
Step By Step: Use the Group, Sort, and Total Pane 

# data[].attributes.subject
Step By Step: Use the Group, Sort, and Total Pane 

# data[].attributes.body
Switch to Layout view and close the Field List pane if it opens. On the DESIGN tab, in the Grouping & Totals group, click the Group & Sort button

Click the Add a group button. Select Region (Borough) from the Group On menu

Click the Add a group button on the Group, Sort, and Total pane. Select Sales Person Last Name from the Group On menu. The report is now also grouped on the Sales Person Last Name field.

Switch to Design view

# data[].attributes.body
On the CREATE tab, in the Reports group, click the Report Wizard button

key the title of your Report.

Click the Finish button to accept the settings