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.
 
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

Subreport with no records 8
subreport totals on Main report 3
SynNeed to account for null values in subreports 2
subreport totals 1
Help With Grand Total for Subreports 16
Grand totals in reports 6
Total Problem 3
Report footer printing on separate page 1

Back
Top