Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError) sql reporting 2008

Question

I am using sql reporting and written query

SELECT * FROM users WHERE created_by = @createdby

and passing parameter using this code in code behind file to call this report.

param[0] = new ReportParameter("@createdby", "1");
       reportviewer.ServerReport.SetParameters(param);

also in rdl file. I have set this paramerter "Set Parameter visibilty" to hidden. It is working fine where I executes this query using query builder, a define query parameter box appears and ask for query parameter. and it works great.

but while passing this parameter using .cs file. It gives error "Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError)".

Answer 1

Per some googling on you behalf I found a possible candidate:

"Navigate to the remote report server management page (http:///Reports/Pages/Folder.aspx). Drill down and hover the cursor over your report, open the menu and select Manage.

On the page that opens, select Parameters and make sure the Hide box is checked for the parameter of concern.

Apply the update, and test."

Let me know if that works out for you.