Sub Reports

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

Guest

Is it possible to calculate a total in a main report from data that is in an
attached sub report? If it is, can you point me to some examples so that I
can understand the syntax?
 
Don said:
Is it possible to calculate a total in a main report from data that is in an
attached sub report? If it is, can you point me to some examples so that I
can understand the syntax?
Click to expand...


The subreport must calculate its own total in it report
footer section.

A main report text box (named txtRunTotal) in the same
section as the subreport can refer to the subreport total by
using an expression like:
=IIf(subreport,Report.HasData, subreport,Report.total, 0)
and set the its RunningSum property to Over All

To display the grand total in the main report's footer
section, use a text box with the expression:
=txtRunTotal
 
Back
Top