Tukai Nancy
Tukai Nancy

Reputation: 127

Combine two expression in ssrs 2008

What is the correct ways to merge or combine 2 expression

=iif(Fields!XXX.Value="Department",56,0)or iif(Fields!YYY.Value="Company",56,0)...

try soo many ways but got an error until i got this,is there any other ways to write this

Upvotes: 1

Views: 1156

Answers (1)

Yuriy Galanter
Yuriy Galanter

Reputation: 39807

Try

=iif(Fields!XXX.Value="Department" or Fields!YYY.Value="Company", 56, 0)

Upvotes: 2

Related Questions