If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Group totals in dynamic report
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! |
#2
|
|||
|
|||
Group totals in dynamic report
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? -- Duane Hookom Microsoft Access MVP "mrashid" wrote: 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! |
#3
|
|||
|
|||
Group totals in dynamic 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])" -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "mrashid" wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|