Ssrs

重載解析失敗

  • November 11, 2017

我正在使用報告服務在我的數據庫中生成一個家庭列表。在列表中的第一個家庭成員之後,我想放家庭的地址:

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

引用自:https://dba.stackexchange.com/questions/100798