CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2ssrs-2012ssrs-tablixssrs-expression
JuniorBI
JuniorBI

Reputation: 13

ssrs expression based on parameter changing

I have two parameters in my chart report A and B. In the series group of chart I have field colour with three colour names("red","green","brown").

Here I need to write an expression when the parameter is "A", I should only see "red",Green" values in the field colour and if it is Parameter "B", I should see all the three colours.

I tried different expressing using

=iif(Parameters!channel.Value="A" and Fields!COLOUR.Value="BROWN",O,Fields!COLOUR.Value)

But by writing this expression I can convert "brown" to zero value but I am not able to hide it.

Any help plz?

Upvotes: 0

Views: 1620

Answers (1)

SouravA
SouravA

Reputation: 5243

Try putting this expression on field color:

"Red, Green"+ iif(Parameters!channel.Value="A", ", Brown","")

+ is used for concatenating two strings.

enter image description here

As put forward,& is a better option for concatenating. 

"Red, Green" & iif(Parameters!channel.Value="A", ", Brown","")

Upvotes: 0

Related Questions