title: iif in SSRS with multiple values
body: <p>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.. </p>