CODEWITHSUNDEEP
reporting-servicesiif
Avinash
Avinash

Reputation: 1313

iif in SSRS with multiple values

I have a field in the report which depends on 3 more fields in the DataSet. The 3 fields are APAC, EMEA and LATAM (Regions). Now There is a Yes and a No in those fields for corresponding Projects. I have to collect the fields with a Yes from each project and display all those regions as Impacted regions in a single field.. Is there a way to do it in SSRS. When I'm using iif I'm only able to display only one region.. supposed if 2 fields have yes, I'm not able to display both..

Upvotes: 0

Views: 16954

Answers (3)

jimconstable
jimconstable

Reputation: 2388

What about concatenating the results?

=iif( Fields!APAC.value = "yes", "APAC ", "") & iif( Fields!EMEA.value = "yes", "EMEA ", "") & iif( Fields!LATAM.value = "yes", "LATAM", "")

Upvotes: 2

gloomy.penguin
gloomy.penguin

Reputation: 5911

Can you try a switch statement?

http://weblogs.sqlteam.com/joew/archive/2008/08/20/60693.aspx

Or... can you say what data type your parameters are and if they are multi-select or single select parameters?

Upvotes: 0

Sam
Sam

Reputation: 7678

Can you use SQL to solve your issue - change the query to return an extra field which is calculated?

Upvotes: 0

Related Questions