We help IT Professionals succeed at work.

Using the 'or' operand

Katy_H
Katy_H asked
on
Medium Priority
265 Views
Last Modified: 2012-05-06
Hi

I'm sure that this is a really basic problem, but I can't seem to get it to work. Basically, I want to suppress  subreport on the basis of either of two reports being null. The formula I have is:

{@Debtor Indicator} <> "" or {@EEC Indicator} <> ""

Either of these works fine, but in combination they don't work. How do I combine them so that the subreport is suppressed if either of the above conditions is met?

Many thanks,
Comment
Watch Question

Commented:
use paranthesis

({@Debtor Indicator} <> "") or ({@EEC Indicator} <> "")

Commented:
IF {@Debtor Indicator} <> "" or IF {@EEC Indicator} <> ""

Author

Commented:
Sorry, Neither of the above suggestions work. I have already tried to use parenthesis and this makes no difference - again either of the two formulas work on their own, but not in combination.

I have also previously tried using the 'IF' function, but this returns an error - 'the keyword 'then' is missing'
Commented:
If IsNull ({@Debtor Indicator})
OR IsNull( {@EEC Indicator} )
then false
else true

Hth,
Spykair

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Commented:
Glad I could help.

Spykair
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.