Share
ReportI am quite new to Dynamics365 and I trying to get distinct values in SSRS Parameter drop-down. And I am using fetch XML(Microsoft dynamics 365 fetch) as the data source connection. I have placed the following code for removing duplicates in the report properties.
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 > 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
Problem is the drop-down is greyed out and not able to choose any values as Parameters. There is not so many resources for Fetch XML.I followed the instruction from this page: https://www.c-sharpcorner.com/article/remove-duplicate-filter-values-from-ssrs-parameter-drop-down/
Need help, struck with this for past 2 days.
All responses (
Answers (
33,626
