Pass NULL along with selected parameter choice from dynamic parameter

Posted on 2011-04-25
Last Modified: 2012-05-11
How do I pass NULL along with the selected parameter value from a dynamic parameter?
I need to show all records that have the selected value for my field AND all records that have NULL for that field too.
I have this for my Select Expert - Record formula: ({Command.FYI FlagTypeID}={?FYI Flag} or isnull({Command.FYI FlagTypeID})or{Command.FYI FlagTypeID}=''). It just returns those records with a value, no records return with NULLs.

I changed it to ({Command.FYI FlagTypeID}={?FYI Flag} and isnull({Command.FYI FlagTypeID}) but no records returned at all.

Thanks in advance for your help!
Question by:wdelaney05
    1 Comment
    LVL 100

    Accepted Solution

    A field cannot be NULL and have a value.  Also you have to test for the NULL first because Crystal terminates the evaluation when it tries to test a NULL field except for IsNull tests

    Try it this way
          isnull({Command.FYI FlagTypeID} OR  {Command.FYI FlagTypeID}={?FYI Flag}


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    779 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

    18 Experts available now in Live!

    Get 1:1 Help Now