Geek Answers Handbook

Error checking parameters. Cannot provide valid values ​​for all parameters. (rsParameterError) sql report 2008

I am using SQL report and written query

SELECT * FROM users WHERE created_by = @createdby

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

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

also in rdl file. I set this parameter "Set visibilty parameter" to hidden. It works fine when I execute this query using the query builder, the query request definition window appears and asks for the query parameter. and it works great.

but when passing this parameter using a .cs file. It gives the error "Error checking parameters." Cannot provide valid values ​​for all parameters. (RsParameterError) ".

+5
source share
3 answers

For some search query from you, I found a possible candidate:

"Go to the remote report server management page (http: ///Reports/Pages/Folder.aspx). Expand and hover over your report, open the menu and select" Management ".

On the page that opens, select "Options" and make sure the "Hide" box is checked for the setting of concern.

Apply the update and test. "

Let me know if this works for you.

+10
source

, , .

VS, - , , .

- ( , , ) , ( , ), , , , .

(https://support.microsoft.com/en-us/help/2146315/recommended-configuration-for-verbose-logging-in-reporting-services), , .

. NULL - , ​​ ( ​​ Internal).

, , Google, , - , .

+1

( ). , ,

, , .

, , XML ""

, -

0
source

More articles:


All Articles