Post reply

Need help on ssrs report parameters or expression

  • October 18, 2019 at 8:43 pm

    #3690318

    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

  • October 19, 2019 at 9:10 pm

    #3690408

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

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

  • October 21, 2019 at 6:29 pm

    #3690709

    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.

  • October 22, 2019 at 1:55 am

    #3690800

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

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

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