Writing an "if-then" expression on a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jenatawp - 16 May 2008 15:41 GMT

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,

Signature

J. Shafer
AWP Industries, Inc.

Reply to this Message

Fred - 16 May 2008 20:15 GMT

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!

> 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
[quoted text clipped - 8 lines]
>
> Best Regards,

Reply to this Message