iif in SSRS with multiple values

0
votes

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..

3
reporting-servicesiif

3 Answers

2
votes

What about concatenating the results?

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

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

0
votes

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?