How to get distinct values of a SharePoint list column using SQL Server Reporting Services

Question

Hi

   i have tried the following link:-
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/6495db18-a1c1-480b-8c92-89c74ee47cf5

Even i am getting error the following error

i have followed your steps, even i am getting the following errors.

"A error occurred during local report processing. The definition of the report '/Manager' is invalid. The report parameter 'Hiddenmanager' has a default value or Valid value that depends on the parameter 'HiddenManager'. Forward dependencies are not valid."

Manager is a parameter. It is followed step 3.

Hiddenmanager is a parameter. It is followed step 1.

if you know any idea, please give me.

Thanks,
Aasai

Answer 1

The order of parameters is wrong. It is important how the parameters appear in the Parameters List.

Change the order of parameters using Up and Down buttons.

Answer 2

Hi Aasai,

Thanks for your posting.

Based on the error message, the issue may occur if the parameter "Hiddenmananger" retrieves values from the main dataset query and you add a filter that contains the parameter to the main dataset. That is to say we cannot use a prameter to filter a dataset from which the parameter retrieve values. To avoid the issue, we can copy the query of the main dataset and create another dataset to provide values for the parameter.

Additionally, to get distinct values of SharePoint lists, you can also refer to the "How do I get distinct values of SharePoint column using SQL Server Reporting Services?" artilce of the "Part III Reporting Services" section of the SQL Server Community FAQs eBook.

Regards,
Mike Yin

---

Mike Yin

TechNet Community Support