我正在使用报告服务在我的数据库中生成一个家庭列表。在列表中的第一个家庭成员之后,我想把家庭的地址:
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
一开始,我以为我的表情会是:
=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 & ")"
)
这会生成“重载解析失败,因为没有可访问的‘IIf’接受这个数量的参数。” 我猜我的 First() 没有正确评估。
我将如何制作这个表达式来实现上述输出?