Group values in a single parameter RRS feed

  • Question

  • Hi All,

    I'm trying to group more values in a single label parameter.

    I'm trying to build up a report related to server in my company and I would like to have a drop down to select server type.

    Drop down should have two categories:



    The field to query can have multiple values to identify Production servers so when I select "Production" the value passed to the query should be "Production,Production_EX" (or something similar to an array of values)

    So I can query as "where servertype IN (@MyParam)

    There's a way to do this?

    Thanks for your help,


    • Edited by GLG_IT Monday, August 3, 2020 4:36 PM
    Monday, August 3, 2020 4:36 PM

All replies

  • hi

    try like the single codes as a whole of double code 


    Thanks and regards

    Monday, August 3, 2020 5:21 PM
  • HI GLG,

    Are you trying to use multi-valued parameter in SSRS to generate a report?

    If so, please follow this SSRS Multi Value Parameter or Using multi-value parameters in SSRS

    Or do you have other specific needs ? You could describe you need and you desired report outcome, so we could understand you report structure and offer better suggestions.



    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    • Proposed as answer by Joy_Zhao Thursday, August 6, 2020 1:20 AM
    Tuesday, August 4, 2020 6:14 AM