Using the 'or' operand

Posted on 2009-02-13
Last Modified: 2012-05-06

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,
Question by:Katy_H
    LVL 26

    Expert Comment

    use paranthesis

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

    Expert Comment

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

    Author Comment

    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'
    LVL 10

    Accepted Solution

    If IsNull ({@Debtor Indicator})
    OR IsNull( {@EEC Indicator} )
    then false
    else true

    LVL 10

    Expert Comment

    Glad I could help.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now