Thursday, August 02, 2012 2:38 PMHi
i have tried the following link:-
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.
Thursday, August 02, 2012 2:48 PM
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.
- Edited by irusulMicrosoft Community Contributor Thursday, August 02, 2012 2:49 PM
Wednesday, August 08, 2012 8:15 AMModerator
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.
TechNet Community Support
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Monday, August 13, 2012 4:50 PM