Subreport Summary

  • Thread starter Thread starter DM - NPS
  • Start date Start date
D

DM - NPS

I have read and followed several of the email strings at this site to learn
how to take a summary field from a subreport and total it on the main report.
I feel like I have everything correct but the summary total is not correct.
Please HELP!!!

The name of the subreport is: joinTreatWO subreport
On the subreport, in the report footer, I have a field called Text13 with
the code: =Sum([AcresTreat]) which gives me a summary of treated acres at
each site.

On the main report, in the report footer I have the following code:

=IIf([joinTreatWO subreport].[Report].[HasData],Nz([joinTreatWO
subreport].[Report].[Text13],0),0)

Eventhough Text13 has some values, I keep getting a summary for all sites of
0.0000. Any Ideas?
 
DM said:
I have read and followed several of the email strings at this site to learn
how to take a summary field from a subreport and total it on the main report.
I feel like I have everything correct but the summary total is not correct.
Please HELP!!!

The name of the subreport is: joinTreatWO subreport
On the subreport, in the report footer, I have a field called Text13 with
the code: =Sum([AcresTreat]) which gives me a summary of treated acres at
each site.

On the main report, in the report footer I have the following code:

=IIf([joinTreatWO subreport].[Report].[HasData],Nz([joinTreatWO
subreport].[Report].[Text13],0),0)

Eventhough Text13 has some values, I keep getting a summary for all sites of
0.0000. Any Ideas?


You can not retrieve the subtotal for each instance of the
subreport in the main report's report footer section. Move
the main report total text box to the same section that
contains the subreport.

OTOH, if you want the main report footer to display a list
of the groups with the total for the group, then you should
create a separate subreport for that specific purpose.
 
Back
Top