Search code examples
sql-serverreporting-servicesssrs-2012ssrs-2017

Can a report parameter label have more than one value in SSRS

I have a parameter that has it's values and labels: Lithuania, Baltics, Europe 1, Europe 2, Europe 3, Europe 4, Europe 5 and ALL as null SSRS parameter Labels and Values

How can I add a new label that has more than one of those values, for example: ALL Europe Export with a value of (Europe 1, Europe 2, Europe 3) Parameter Labels and Values with the new Label

Is there a way to to add a label with multiple values in SSRS or should it be done in SQL Management Studio?

Solution

  • I have found a way through the query/procedure:

    WHERE ((@area = 'ALL EUROPE EXPORT' and a.Area in ('Baltics', 'Europe 1', 'Europe 2', 'Europe 3', 'Europe 4', 'Europe 5')) or (@area = 'LITHUANIA' and a.Area = 'Lithuania') or (@area = 'BALTICS' and a.Area = 'Baltics') or (@area = 'EUROPE 1' and a.Area = 'Europe 1') or (@area = 'EUROPE 2' and a.Area = 'Europe 2') or (@area = 'EUROPE 3' and a.Area = 'Europe 3') or (@area = 'EUROPE 4' and a.Area = 'Europe 4') or (@area = 'EUROPE 5' and a.Area = 'Europe 5') or @area is null)

    And then in parameter values I added all those upper case names.