Adding Formulas from subreport to main report 1

[deb9105]

I have created a report that is pulling data for a benefit ending date for a select group for their medical benefits then another report with another ending date for the remaining benefits.
I tried an if statement on the main report, but it pulls the data for all benefit end dates.
Ex: If plancode is "DB" then planendate is #12/31/2004#else if plancode is "LTD" then planendate is #06/30/2005#
Since their is multiple end dates for the medical, I get all endates information.
So, I tried creating a report with just the other benefit data and then a subreport with the medical benefits with the end date of #12/31/2004#
I need to total all costs of benefits from the main report and the subreport. How do I do that?

 

[KKond]

use shared variable if subreport. call it in main report and then do u'r calculations

 

[Madawc]

Look here for details of how to use subreports. Remember that they can only be used in the main-report section below the section that calls the subreport.

Madawc Williams (East Anglia, UK)

 

[Madawc]

The last post was unclear, sorry. What I meant was:

Look here for details of how to use shared variables. Remember that they can only be used in the main-report section below the section that calls the subreport.

Madawc Williams (East Anglia, UK)