Loading

Add If statement in Expression in Report service

Ramadan Elmahdy

Hello All

i have table in report in this table filed view number

i want this number replaced by name

i have just 4 numbers ( 0-1-2-3)

if this id = 0 want write "name 1"

if this id = 1 write "name 2"

if this id = 2 write "name 3"

if this id =3 write "name 4"

i try expression

where can i write if in this screen

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
Accepted answer
Try the following:
=IIF(Fields!RequestTypeId.Value = 0, "Name 1", IIF(Fields!RequestTypeId.Value = 1, "Name 2", IIF(Fields!RequestTypeId.Value = 2, "Name 3", "Name 4" ) ) )
Obviously, I am not been able to test it.
Ramadan Elmahdy10y ago
thanks
i try that and done