Conditional filter in SSRS Dataset issue RRS feed

  • Question

  • Hello, I have a report using multiples parameters, allowing multi values.  I'm getting all data from my sql query even those there are null in those fields.  I need to include this as well in my report

    I have a filter dataset like as fields!Name.Value in  Parameters!ListNames.Value but doesn't include in the report those records with fields!Name.Value  = Null. I'm reading that is possible to use OR condition in a filter expresion but it doesn't work for me..

    I trying to add a Filter expression

    Fields!NAME.Value = Parameters!Installer.Value or Fields!NAME.Value is nothing

    Fields!NAME.Value = Parameters!Installer.Value orELse Fields!NAME.Value = " "

    But always I got the error  "Failed to evaluate the filterValues of the Dataset ...... "
    I'm very appreciate if someone can help me!!!



    Wednesday, May 16, 2012 11:36 PM

All replies

  • Hi There

    Can you please advise me whether your Parameters!Installer.Value  is a multivalued Parameter

    Are your trying to put filter on your dataset or on your Tablix then I might be able to help you

    Many thanks

    Syed Qazafi Anjum

    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

    • Proposed as answer by Lola Wang Friday, May 18, 2012 7:05 AM
    Wednesday, May 16, 2012 11:55 PM