Sample Header Ad - 728x90

Overload resolution failed

0 votes
1 answer
1797 views
I am using reporting services to generate a list of families in my database. After the first family member in the list, I want to put the family's address: family, First 123 la la lane Somewhere, Ca 90210 famliy, Second family, Third two, first 345 zippy st Nowhere, UT 85763 two, second two, third At first, I thought my expression would be: =IIF(First(Fields!person_id.Value) = Fields!person_id.Value, Fields!last_name.Value & " " & Fields!person_suffix.Value & ", " & Fields!person_title.Value & " " & Fields!nick_name.Value & " (#" & Fields!person_id.Value & ")" & vbcrlf & Fields!address.Value & vbcrlf & Fields!city.Value & ", " & Fields!state.Value & " " & Fields!postal_code.Value, Fields!last_name.Value & " " & Fields!person_suffix.Value & ", " & Fields!person_title.Value & " " & Fields!nick_name.Value & " (#" & Fields!person_id.Value & ")" ) This is generating a "Overload resolution failed because no accessible 'IIf' accepts this number of arguments." I am guessing my First() does not evaluate properly. How would I craft this expression to achieve the above output?
Asked by AWippler (101 rep)
May 6, 2015, 08:03 PM
Last activity: Nov 11, 2017, 07:29 PM