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

missing or invalid parameter value. please input valid data for all parameters

4 Answers 1837 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
waqas
Top achievements
Rank 1
waqas asked on 16 Jan 2018, 05:21 PM
Hi
I creating a simple List report. When I tries to add parameter and fill it from data source I am getting this exception
missing or invalid parameter value. please input valid data for all parameters 

Can any one help please..


Thanks

4 Answers, 1 is accepted

Sort by
0
Simon
Top achievements
Rank 1
answered on 11 Oct 2018, 08:25 AM

Hello,

thats my problem too.

Has someone a solution?

0
Silviya
Telerik team
answered on 16 Oct 2018, 05:53 AM
Hi Waqas and Simon,

Is it a single value or multi value parameter?
Please double-check if  the data source parameters are mapped to report parameters (step 4 in the SqlDataSource Wizard help 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.

Regards,
Silviya
Progress Telerik
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
0
Laure
Top achievements
Rank 1
Iron
answered on 02 Feb 2021, 01:49 PM

Hi, 

I had the same problem, In fact, it is not a bug.

When you add a report parameter to your report, you should set the parameters value. If not, you get this error.

The report parameters have a property named AcceptsNull which is set to false. If you turn it to true, you will not get this error.

 

1
Magnus
Top achievements
Rank 1
Iron
answered on 01 Mar 2022, 10:17 AM

Hello,

Is there any way to know which parameter is missing valid data?

- Magnus

Dimitar
Telerik team
commented on 04 Mar 2022, 07:35 AM

Currently, there is no way to get to know exactly which report parameter has missing or invalid data besides checking their values in the designer.

You may make a feature request on our feedback portal for a more informative error message when the value of a report parameter is incorrect. For example, you may request for the report parameter name(s) to be included in the error message.

Magnus
Top achievements
Rank 1
Iron
commented on 04 Mar 2022, 08:29 AM

Thanks for your suggestion Dimitar, I have posted my request here: https://feedback.telerik.com/reporting/1556294-more-informative-error-messages-for-invalid-parameter-value
Tags
General Discussions
Asked by
waqas
Top achievements
Rank 1
Answers by
Simon
Top achievements
Rank 1
Silviya
Telerik team
Laure
Top achievements
Rank 1
Iron
Magnus
Top achievements
Rank 1
Iron
Share this question
or