[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

Using the 'or' operand

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,
0
Katy_H
Asked:
Katy_H
1 Solution
 
tigin44Commented:
use paranthesis

({@Debtor Indicator} <> "") or ({@EEC Indicator} <> "")
0
 
spangdeltaITCommented:
IF {@Debtor Indicator} <> "" or IF {@EEC Indicator} <> ""
0
 
Katy_HAuthor 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'
0
 
SpykairCommented:
If IsNull ({@Debtor Indicator})
OR IsNull( {@EEC Indicator} )
then false
else true

Hth,
Spykair
0
 
SpykairCommented:
Glad I could help.

Spykair
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now