Need help with Sums in subreports 2

[ZappaDog]

I have a main report called Production By Week. This contains a subreport for each production line.

Each subreport is based on a crosstab query with row headings for partname, partnumber, and total production. My column headings are 1-7 for the days of the week.

In the report footer of subreports, I sum the production for each day, count the days of production, and average the production by days of production and by total days(7).

I am now keeping track of production based on shift (day/night) as well as date. I have added shift into my crosstab query, and they are differentiated on report. What I am trying to do is have sum and averages of production by shift, as well as daily totals and averages.

If anyone has any idea on how I should approach this, please let me know.

Thanks

 

[KenReay]

Hi

In your SubReport, Group by Shift, hide the Group header, in the Group Footer, put 'Sums' similar to what you did for the report footer. Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[ZappaDog]

Thanks KenReay,

That worked great.