Subreport "Sum"

[Guest]

I have a main report with 4 subreports. In each subreport is a field for a
dollar amount to be inputed. Is there a way to sum these fields from these
seperate subreports in the main report under an unbound text box? If not,
any suggestions?

 

[Marshall Barton]

I have a main report with 4 subreports. In each subreport is a field for a
dollar amount to be inputed. Is there a way to sum these fields from these
seperate subreports in the main report under an unbound text box? If not,
any suggestions?

Isn't his essemtially the same question you asked a couple
of hours eariler. If it is, the answer is also the same.

 

[Guest]

Yes, but I didn't see that question ever post on the website...so I tried it
again and still don't see the original...so will someone answer my question
without nasty comments. Thank you.

 

[Marshall Barton]

Here's a copy of my reply to your other post:
---------------------------------------
If the values you want to retrieve from the subreport is in
the Report Header or Footer section, then Yes.

The expression in the total text box would look like:

=subreportcontrol1.Report.value1 +
subreportcontrol2.Report.value2 + . . .

If there's a chance that a subreport may not have any data,
then use this:

=IIf(subreportcontrol1.Report.HasData,
subreportcontrol1.Report.value1, 0) + . . .