Multivalue Paramater is problem in SSRS 2008

  • Dose JOIN function in Report will work if yes then how?

  • Client has two environment Acceptance & Production

    and i have developd report in in Vosual studio 2008 and SQL 2012

  • Sorry for giving wrong info about VS 2010

  • Dinesh R. Nandwalkar (8/5/2014)


    Dose JOIN function in Report will work if yes then how?

    That will work when you want to display the values of the parameter into a textbox.

    Not sure how it will help when passing the values to a query.

    I would use a stored procedure, split out the values in the sp, store them in a table variable and use those in the final query.

    More info on multi-values parameters can be found in this article:

    Using Parameters in Reporting Services Reports (Part 2)[/url]

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 16 through 18 (of 18 total)

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