Sub Report Values

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

I am stumped with this problem and I would like to share with this group,
thank you in advance.

I have a main report (Report A) which consists of two sub reports
SubReport_b and SubReport_c. SubReport_b generates a total credit for an
individual. SubReport_c generates a sum of payments made toward toward
credit for the same individual, which is reported in SubReport_b.

I would like to make a third sub report, SubReport_d, which reports
outstanding credit balance for an individual(the same individual in _b and
_c), which is the value of SubReport_b - SubReport_c. Is there a simple way
that I can perform a subtraction between SubReport_b - SubReport_c and have
that value report into either a textbox control on Report A or into a
textbox on SubReport_d?

I am just not heading in the right direction and could use a little
guidance. Thank you again.
 
Instead of making yet another sub-report, why don't you simply have the "x-y"
information in the footer section of the main report?

Makes sense?
 
news.microsoft.com said:
I am stumped with this problem and I would like to share with this group,
thank you in advance.

I have a main report (Report A) which consists of two sub reports
SubReport_b and SubReport_c. SubReport_b generates a total credit for an
individual. SubReport_c generates a sum of payments made toward toward
credit for the same individual, which is reported in SubReport_b.

I would like to make a third sub report, SubReport_d, which reports
outstanding credit balance for an individual(the same individual in _b and
_c), which is the value of SubReport_b - SubReport_c. Is there a simple way
that I can perform a subtraction between SubReport_b - SubReport_c and have
that value report into either a textbox control on Report A or into a
textbox on SubReport_d
Click to expand...


No need for a subreport_d. Use a text box on the main
report with an expression like:

=IIf(SubReport_b.Report.HasData, SubReport_b.Report.totcred,
0) - IIf(SubReport_c.Report.HasData,
SubReport_c.Report.totpay, 0)
 
Back
Top