0

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?

0

I needed to include the context: First(Fields!person_id.Value,"FamilyID") = Fields!person_id.Value

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.