I have numerous groups based on a customer number in the table. I created a report and set it up so it reports by groups. Since these groups represent a separate customer, I want each group to print on a new page. Of course if one group report goes over a page it will print as needed on new pages but it must separate each group by a page also. As it is now I have searched over and over trying to find a way to put a forced page in the design view but cant seem to make it work. I am still looking for a way to do a total of one of the fields on the report also. Is that possible??
So far I have had to create a separate report for each grouping to be able to print it on a separate page. That has been real cumbersome with a ton of groups (customers).