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
Last activity: Nov 11, 2017, 07:29 PM