title: SSRS : Filter Duplicate Values simple no multiple values allowed
body: <p>I am trying to create a parameter for date which filters the duplicate date values so that dropdown shows only distinct values. I have tried the steps mentioned in the following link <a href="https://blogs.msdn.microsoft.com/sqlforum/2011/04/27/walkthrough-how-to-get-distinct-values-of-a-column-of-a-sharepoint-list-using-sql-server-reporting-services/" rel="nofollow noreferrer">https://blogs.msdn.microsoft.com/sqlforum/2011/04/27/walkthrough-how-to-get-distinct-values-of-a-column-of-a-sharepoint-list-using-sql-server-reporting-services/</a> but its only for mutiple select not for single select. Can anyone suggest steps and code for single select ? 
  Also here is the same code as mentioned in the link I have tried :-</p>
  
  <pre><code>Public Shared Function RemoveDuplicates(parameter As Parameter) As String()
  
  Dim items As Object() = parameter.Value
  System.Array.Sort(items)
  Dim k As Integer = 0
  
  For i As Integer = 0 To items.Length - 1
  If i &gt; 0 AndAlso items(i).Equals(items(i - 1)) Then
  Continue For
  End If
  
  items(k) = items(i)
  k += 1
  Next
  Dim unique As [String]() = New [String](k - 1) {}
  System.Array.Copy(items, 0, unique, 0, k)
  
  Return unique
  End Function
  </code></pre>