|
If you have successfully tackled the process of grouping in a report; then you may wish to have all the relevant information for one group on one page and the next grouping on the following page, etc. To do this you need to:
- Open the report in Design View;
- Click on the Grouping and Sorting Button;
- Make sure the field you have grouped is selected and change group footer to ‘Yes’. This creates a group footer;
- Close the sorting and grouping window;
- Right Click on the Group Footer Divider and click on ‘Properties’ to open the properties window;
- Click on the ‘Format’ tab;
- Select ‘After Section’ for the ‘Force New Page’ property;
- Close the properties window, and check the new layout by print previewing your report.
Do you like this tip? Subscribe to my weekly Newsletter to receive tips
weekly via email.
Click Here to subscribe.
|
