Keep getting "missing or invalid parameter value"

[David]

I keep getting "missing or invalid parameter value" "please input valid data for all parameters" when previewing my report. I've set up a SqlDataSource with the "Configure.." wizard. I have two parameters, both of type int/integer/Int32. When I run the "Excecute query" in the Configure-wizard I get the expected result in the results list. But, when I preview the report I get "missing or invalid parameter value" "please input valid data for all parameters"...

 

I've checked every parameter mapping in the report and everything looks ok.

I've attached the report causing this.

What could cause this?

 

//Thomas

[David]

Nope, couldn't attach the files.

[Stef]

Hi David,

Please rerun the SqlDataSource Wizard and verify the SQL parameters are mapped to report parameters (step 4 in the linked article). Then you will be asked for sample values to execute the query and get results (the fields for the Data Explorer).

You can provide initial values by setting the parameters' Value properties on designing the report. Or you can set each report parameter's Visible property to true, and the used viewer will display its parameters area.

Initial values can be specified by listing the report parameters' name (case sensitive) and the new values in the used viewer's ReportSource.Parameters collection - Report Source Parameters.


On a side note, forums allow only image attachments. You can use the support ticketing system for other files - 20MB per attachment, ZIP format is recommended.


Let us know if you need further help.

Regards,
Stef
Telerik by Progress