Subreport and Main reports

  • Thread starter Thread starter Kathleen Badeaux
  • Start date Start date
K

Kathleen Badeaux

How do I add the subreport total to the main report total
to get a grand total?
 
Copy your Text box fields into the report footer section of the report. This should give you a grand total
 
Kathleen said:
How do I add the subreport total to the main report total
to get a grand total?
Click to expand...


A main report text box (in the same section as the
subreport) can refer to a total in a subreport's report
footer section by using an expression like:

=subreportcontrol.Report.subtotaltextbox

If the subreport might possibly not have any data, then you
can use a more elaborate expression to use a zero when there
is no data in the subreport:

=IIf(subreportcontrol.Report.HasData,
subreportcontrol.Report.subreporttotaltextbox, 0)

To get the main report to add up these values, set the main
report's subtotal text box's RunningSum property to Over All
or Over Group as appropriate.
 
Back
Top