Report totals

  • Thread starter Thread starter Deanna S via AccessMonster.com
  • Start date Start date
D

Deanna S via AccessMonster.com

I have a complex dynamic report generater w/up to 4 group levels. Simplified,
the report displayed may consist of something like this:
Department (group)
Staff member (group)
Training event for the staff member (group)
Type of training (can be more than 1) (detail)

So let's say I filter the recordset by the location of the training event. I
then want a count within the department grouping of the total # training
events. If I just do a count(*), the count is too high because each event may
have several types of training associated with it so each detail is counted.
I can't put the Type of training on a subreport because sometimes the report
recordset will be filtered by type of training. I realize I could use DCount
instead of Count, but the recordset of the report is always created
dynamically. Any suggestions on how I can generate the counts at various
group levels?

Thanks!
Deanna
 
Deanna said:
I have a complex dynamic report generater w/up to 4 group levels. Simplified,
the report displayed may consist of something like this:
Department (group)
Staff member (group)
Training event for the staff member (group)
Type of training (can be more than 1) (detail)

So let's say I filter the recordset by the location of the training event. I
then want a count within the department grouping of the total # training
events. If I just do a count(*), the count is too high because each event may
have several types of training associated with it so each detail is counted.
I can't put the Type of training on a subreport because sometimes the report
recordset will be filtered by type of training. I realize I could use DCount
instead of Count, but the recordset of the report is always created
dynamically. Any suggestions on how I can generate the counts at various
group levels?
Click to expand...


Use a text box named txtTrainingCount in the training
header or footer section. Set its control source to =1 and
RunningSum to Over Group.

Then a staff member footer section text box can display the
training events by using the expression =txtTrainingCount

To add up the total across all members in a department, add
a textbox named txtMemberTraining, set its control source
to =txtTrainingCount and set its RunningSum to Over Group.
THen the department footer text box can display its total by
using the expression =txtMemberTraining
 
Back
Top