Subreport Totals

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

I have a main report that has grouping on a date field.
I also have subreports that are tied to the main report
and print along with it. I total a transaction field for
the main report in the group footer. I also want to
total a subreport field for the same group and print in
the group footer.

I have tried all I knew how and read all I could but
still must be missing something.

How is this accomplished?
 
dave said:
I have a main report that has grouping on a date field.
I also have subreports that are tied to the main report
and print along with it. I total a transaction field for
the main report in the group footer. I also want to
total a subreport field for the same group and print in
the group footer.
Click to expand...

Add a text box named txtRunTrans to the main report section
yhay contains the subreport. Set its control source
expression to:
=IIf(subreport.Report.HasData,subreport.Report.totaltextbox,0)
and set its RunningSum property to Over Group.

Then the main report's group footer can display the total
transactions in the group footer by using a text box with
the expression:
=txtRunTrans
 
Back
Top