我有以下查找自定义代码:
Function SumLookup(ByVal items As Object()) As Decimal
If items Is Nothing Then
Return Nothing
End If
Dim suma As Decimal = New Decimal()
Dim ct as Integer = New Integer()
suma = 0
ct = 0
For Each item As Object In items
suma += Convert.ToDecimal(item)
ct += 1
Next
If (ct = 0) Then return 0 else return suma
End Function现在,我想在表达式中使用如下:
=Code.SumLookup(LookupSet(Fields!sJerarquiaNivel2.Value,Fields!Unidad.Value,Sum(Fields!InventarioSobreVentas.Value, "DS_DataInventarioDosAniosAnterior"))问题是,当我运行项目时,我得到:
表达式函数“LookupSet”的参数数不正确
我做错了什么?问候
发布于 2018-01-23 22:32:25
您需要关闭SUM末尾的括号
试一试
LookupSet(Fields!sJerarquiaNivel2.Value,Fields!Unidad.Value,Sum(Fields!InventarioSobreVentas.Value), "DS_DataInventarioDosAniosAnterior")https://stackoverflow.com/questions/48411450
复制相似问题