Page and total for group by report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Le Tran said:
Hi there,
I make a report that allow to print all the chemicals that one professor
Click to expand...
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)
Click to expand...
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.
Click to expand...
Please help if you have any suggestions.
 
Back
Top