开发者

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?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜