I have a report, which lists the staff in several offices throughout the UK (the user can select which offices to include). Users want each office to be on a seperate page, so I have put a page break in the footer of the office group. I have also put a label in the footer, which displays the number of people in each office.
Users also want the total number of people in each report. I have placed a label in the report footer, which counts the number of people, but because of the page break in the office group footer, this displays on a seperate page.
Is there any way to have the total number of people to display on the same page as the last office, without having it display on every page?
TIA
Users also want the total number of people in each report. I have placed a label in the report footer, which counts the number of people, but because of the page break in the office group footer, this displays on a seperate page.
Is there any way to have the total number of people to display on the same page as the last office, without having it display on every page?
TIA