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..开发者_如何学JAVA
What about concatenating the results?
=iif( Fields!APAC.value = "yes", "APAC ", "") & iif( Fields!EMEA.value = "yes", "EMEA ", "") & iif( Fields!LATAM.value = "yes", "LATAM", "")
Can you use SQL to solve your issue - change the query to return an extra field which is calculated?
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?
精彩评论