我在用着Join(Lookupset)
查找返回序列号的唯一组值。这是我的功能:
Join(LookupSet(Fields!itemId.Value & Fields!UseByDate.Value & Fields!rackId.Value
, Fields!itemId.Value & Fields!UseByDate.Value & Fields!rackId.Value
, Fields!CustomerSeqNo.Value
, "PickingList"), ",")
问题是某些商品存在多次交易。我想删除重复项。
我找到了一个博客http://blogs.msdn.com/b/bobmeyers/archive/2012/06/18/creating-short-lists-using-the-lookupset-function.aspx http://blogs.msdn.com/b/bobmeyers/archive/2012/06/18/creating-short-lists-using-the-lookupset-function.aspx但无法让 SSRS 报表生成器引用 Linq 程序集。我的问题是
我怎样才能展示独特的价值观?
您不需要 Linq,但仍然需要自定义代码(在 BIDS 中,转到“报告”->“报告属性”->“代码”)
您可以在此处放置一个RemoveDuplicates 函数,如下所示:
Public Shared Function RemoveDuplicates(m_Array As Object()) As String()
System.Array.Sort(m_Array)
Dim k As Integer = 0
For i As Integer = 0 To m_Array.Length - 1
If i > 0 AndAlso m_Array(i).Equals(m_Array(i - 1)) Then
Continue For
End If
m_Array(k) = m_Array(i)
k += 1
Next
Dim unique As [String]() = New [String](k - 1) {}
System.Array.Copy(m_Array, 0, unique, 0, k)
Return unique
End Function
要在您的加入中使用它:
Join(Code.RemoveDuplicates(LookupSet(...)),",")
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)