Group totals in dynamic report

  • Thread starter Thread starter mrashid
  • Start date Start date
M

mrashid

I have a report that dynamically gets control source for five columns based
on user input through a form. The report successfully shows text boxes
(currency format) with approporiate fields (control source) and respective
data. I then have unbound text boxes for each of the five columns to show
group totals. I haven't been able to get it working. For example, one of the
text boxes' name is txtPeriod1 and based on user selection the field is
MAY_PYR. The group total should show Sum(MAY_PYR); it works through hard
coding but not dynamically and keeps prompting to enter "txtPeriod1"
parameter. Please suggest solution. Thanks in advance!
 
Not enough information...
Are the dynamic columns derived based on months?
Why are they dynamic?
How do you get and set the record source of the report?
 
Presumably you are using Report_Open to assign the ControlSource of the text
boxes, based on the actual field names.

You can also assign the ControlSource of the total box in the group footer,
e.g.:
Me.Total0.ControlSource = "=Sum([Field99])"
 
Thanks folks. I actually got it working using Domain Sum. Sorry for delayed
reply.

Thanks again!

Allen Browne said:
Presumably you are using Report_Open to assign the ControlSource of the text
boxes, based on the actual field names.

You can also assign the ControlSource of the total box in the group footer,
e.g.:
Me.Total0.ControlSource = "=Sum([Field99])"

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


mrashid said:
I have a report that dynamically gets control source for five columns
based
on user input through a form. The report successfully shows text boxes
(currency format) with approporiate fields (control source) and respective
data. I then have unbound text boxes for each of the five columns to show
group totals. I haven't been able to get it working. For example, one of
the
text boxes' name is txtPeriod1 and based on user selection the field is
MAY_PYR. The group total should show Sum(MAY_PYR); it works through hard
coding but not dynamically and keeps prompting to enter "txtPeriod1"
parameter. Please suggest solution. Thanks in advance!
Click to expand...

.
Click to expand...
 
Back
Top