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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SynNeed to account for null values in subreports 2
Subreport Page footer does NOT display 4
count in parent report footer 2
Subreport Summary 1
Counting and totaling from a subreport 6
Help With Grand Total for Subreports 16
subreport/report total question 5
Subreport Totals 10

Back
Top