This is a migrated thread and some comments may be shown as answers.

Keep getting "missing or invalid parameter value"

2 Answers 570 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
David
Top achievements
Rank 1
David asked on 17 Nov 2016, 09:52 AM

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

2 Answers, 1 is accepted

Sort by
0
David
Top achievements
Rank 1
answered on 17 Nov 2016, 09:54 AM
Nope, couldn't attach the files.
0
Accepted
Stef
Telerik team
answered on 17 Nov 2016, 05:56 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
David
Top achievements
Rank 1
Answers by
David
Top achievements
Rank 1
Stef
Telerik team
Share this question
or