Need help on ssrs report parameters or expression

  • Dee Dee-422077

    SSC Eights!

    Points: 913

    Hi,

    I have created an SSRS report that renders a table from my DB. I have created a multi-value text parameter separate by ','

    In My dataset, I use (WHERE col1 IN (@parm))  and the data set parameter,  I have the expression : =split(Parameters!Myvalue.Value,",")

    All work fine when I run the report and enter in 1 or multiple value.... BUT I'd like when type in the text box  * or leave it blank, it will load ALL Data... Please advise how I can do this.

    Thanks,

    Ddee

  • Site Owners

    SSC Guru

    Points: 80378

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • doug.brown

    SSCertifiable

    Points: 5540

    Try adding to your query something like:

    WHERE (col1 IN (@parm) or @parm IS NULL)

    Then in Visual Studio make sure the parameter @parm can be NULL.

  • Sumathi

    SSC Rookie

    Points: 28

    Set a default value to the parameter and validate against that default to identify blanks.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply