Writing an "if-then" expression on a report

[jenatawp]

I am trying to add a field on my report that will look up information in its
subreport. There is a field that tells me if the record is "open" or
"closed". If the record is "open", then I would like it to sumthe amount in
another field on the same subreport. This is in a database that I am using
to track open delinquent invoices, so I am trying to get it to show me how
much a particular company owes.

Can anyone share with me how I can accomplish this?

Thank you in advance for your assistance.

Best Regards,

 

[Fred]

Dear jenatawp,

Maybe someone else can work from this but in my opinion, id data terms:

You didn't tell us much about the underlying task you are trying to do,
instead you are telling us a (probably faulty) way that you are trying to do
it and then about a problem you ran into using that method.

Reports get data from data sources and then print / display it. They don't
get data from reports. And you have told us zero about your data sources /
tables. So you may need to redescribe that.

My guess is that your solution will be in table structures, after with the
report part will be easy.

Hope this helps at least a little!