Summing totals from a subreport

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

Guest

How can I enter a formula in a group footer that will sum a footer subtotal,
plus a total reported in a subreport?
 
GeorgeH said:
How can I enter a formula in a group footer that will sum a footer subtotal,
plus a total reported in a subreport?
Click to expand...


You can retrieve the value of a subreport total by using the
expression:

=IIf(subreport.Report.HasData, subreport.Report.textbox, 0)

You can use that text box's RunningSum property to get it to
add the subreport values. A report footer text box can then
display the grand total by referring to the running sum text
box.

The grand total can combone the sum of other fields with the
total running sum value by using a simple expression:

=Sum(fieldA) + Sum(fieldB) + txtRunnungTotal
 
Back
Top