Click here to Skip to main content
15,889,824 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
In my report, I get the DataSet from the OLAP Analysis Server. Then add a calculated filed to the DataSet based on one existed field. Now I want to add a parameter to the report by using the calculated field. After a preview, I find there is duplicate items in the parameter list. How can I make a distinct list?
I have tried to add code to remove the duplicates, but no success.
reference to the code snippet here. http://blogs.msdn.com/b/sqlforum/archive/2011/04/28/walkthrough-how-to-get-distinct-values-of-a-column-of-a-sharepoint-list-using-sql-server-reporting-services.aspx[^]

Some Update for the question.
I have managed to make the sample code work by adding a parameter based on the calculated filed mentioned above. It is stupid as I need to first make a select for this dummy parameter and then the distinct parameter list will show. After a dig, it should be caused by the dummy parameter cannot be set some default value.
Any suggestion on this?
Posted
Updated 2-Sep-13 20:00pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900