Page and total for group by report

[Le Tran]

Hi there
I make a report that allow to print all the chemicals that one professor have in all his lab rooms. I have the total chemicals that he has. I group by location (lab rooms
what I want to do now is
1. Calculate how many chemicals in one location (lab room) and it can appear in the report
2. For a another location (another lab that this professor is supervise) the report should be in a new page of this report.

I do not know how to calculate for each location and set up the pape. Please help if you have any suggestions
Thank you for your continued help
Regards
Le Tran

 

[Newbie]

Group your report by Professor and Location
Have a footer for Location
In the footer for the Location put your count expression and also a page
break

HTH

Hi there,
I make a report that allow to print all the chemicals that one professor

have in all his lab rooms. I have the total chemicals that he has. I group
by location (lab rooms)

what I want to do now is
1. Calculate how many chemicals in one location (lab room) and it can appear in the report.
2. For a another location (another lab that this professor is supervise)

the report should be in a new page of this report.

I do not know how to calculate for each location and set up the pape.

Please help if you have any suggestions.