Check if multiple fields are missing

Question

I have a dynamic dataset, and I want to show a row if any one of the filds are in the dataset. I know how to check for one, but not multiple

=IIf(Fields!aValue.IsMissing, False, True )

I need to check 3 fields: aValue, bValue, cValue

---

www.helixpoint.com

Answer 1

=IIf(Fields!aValue.IsMissing, False, True ) && IIf(Fields!bValue.IsMissing, False, True ) && IIf(Fields!cValue.IsMissing, False, True )

Use as above with multiple columns.

---

Please Mark posts as answers or helpful so that others can more easily find the answers they seek.