Subreport "Sum"

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Lori said:
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?
Click to expand...


Isn't his essemtially the same question you asked a couple
of hours eariler. If it is, the answer is also the same.
 
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.
 
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) + . . .
 
Back
Top