My report needs to consist of 2 parts. The first part being the detail lines which is working fine, and the second part being the report totals page which is where i am stumped.

 

Here is an example of what I am trying to do:

 

<these are the detail lines, each dept prints on a new page, the values are hours worked etc, the DEPT is a group and the Jobs are grouped also in order to get the data summarized>

 

DEPT 1

     Job 1     1.00   

     Job 2     3.00

     Job 3     1.00

 

DEPT 2

     Job 1     2.00

     Job 3     4.00

 

at the end of the report, i am wanting to generate a report total that would look like:

 

JOB TOTALS

     Job 1    3.00

     Job 2    3.00

     Job 3    5.00

 

Any advice would be appreciated. Thanks!