Help with Calculations in footer of report

[rhett7660]

Hello all...

Here is what I have. A report with various calculations:

Here is the layout:

YesNoTypeHeader
YesNoType txt field

TypeHeader
Type txt field

GenderHeader
Gender txt field
Count of Gender

YesNoFooter
Total Females with abs sum
Total Male with abs sum
Total Adds both up

Report footer
Total for job A
Total for job B
Tobal for job C

Total count(yesno)
Female abs sum
Male abs sum

What I would like to do is in the footer have the following:

Total for Job A
Male total #
Female total #

Total for Job B
Male total #
Female total #

Total for Job C
Male total #
Female total #

I can't get the totals for the gener for each job. Hope this makes sense.

Any suggestions?

Thanks

 

[khawar]

You can use subreport in the footer section

 

[rhett7660]

Hmmm..... That is an idea I didn't think of. Trying it out now.