Ssrs
重載解析失敗
我正在使用報告服務在我的數據庫中生成一個家庭列表。在列表中的第一個家庭成員之後,我想放家庭的地址:
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() 沒有正確評估。
我將如何製作這個表達式來實現上述輸出?
我需要包括上下文:
First(Fields!person_id.Value,
“FamilyID”) = Fields!person_id.Value