locked
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:

    Production

    Non-Production

    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,

    GLG


    • 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 

    "'Production','Production_EX'" 

    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.

    Regards,

    Joy


    ""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