I have multiple reports created in Report Designer with the same error condition. Each has one or more report parameters that have an entity datasource (sql server stored procedure) and set to multivalue=true and set to null=yes and have no initial value set. These are passed as arguments to the stored procedure for the main datasource. Having no selections is a valid condition.
When run through our web application, when the report initially displays each of those multi-select parameters it displays the "Please input a valid value" error message. Usually when this happens, the report engine pauses, additionally displays the "Please input valid data for all parameters" message as well, then waits for more user input.
However this is not happening: the "Please input..." message is not being displayed, and the report jumps right in and does an initial rendering to the web page. This indicates it thinks it does not have any invalid parameters. Yet, the Preview button is not clickable indicating it thinks there are invalid parameters. Very confusing.
The work-arounds include:
1) Select one item in the parameter list, then un-select it. Now the Preview button works.
2) In report designer, force an initial selection of one item in the report parameter.
3) In report designer, change the report parameter to be single value instead of multi value.
4) In report designer, run the report in preview mode - it runs fine with no error messages.
None of these are good solutions of course. So I need to know how to suppress the seemingly erroneous parameter errors.
Telerik 11.0.17.118 Windows 10 VS 2015 SQL Server 2016. This happens when running locally through VS as well as when deployed to a separate server.
Thanks.
5 Answers, 1 is accepted
Thank you for posting the details.
This is a known issue with the validation included in the HTML5 Viewer's Parameters area. It affects multivalue report parameters with AllowNull set to true.
until there is an official fix, the workaround is to set default value for each report parameter on designing the report.
Regards,
Stef
Telerik by Progress
Rank 1
You can use hidden report parameters, without available values (this will be bring better performance on processing). Then create custom UI that updates the viewer's reportSource.parameters with the selected values e.g. How To: Pass Values to Report Parameters.
I hope this helps.
Regards,
Stef
Telerik by Progress
Rank 1
Hello Stef,
I just encountered the same problem with the Html5 ReportViewer version 11.0.17.118. I am designing a report that will have four optional MultiValue=true, AllowNull=true parameters, which works correctly when previewed in the Designer but when hosted in the website displays the message "Please input a valid value" and requires an entry before the Preview button is enabled. Interestingly enough, if you select and then de-select a value in each box then the message is removed and the Preview button stays enabled. However, it is not practical to force the user to enter and remove four values before running the report!
Do you know if this issue has been corrected in a later release, or when the fix might be made available?
Regards,
Don Neeper
CGI Federal
Below is a quote from my response in your support ticket about this question:
We are aware of this validation issue of multivalue report parameters with set AllowNull=true. The HTML5 Viewer cannot validate the null value and requires the user to select a value initially. If you clear the selection and preview again, the viewer submits correctly the null value.The task is in test stage and a fix will be released in a consecutive internal build (no ETA, but we release internal builds on several weeks interval).For the time being, you can test using custom UI that updates the HTML5 Viewer in JavaScript - How To: Pass Values to Report Parameters.If you need further help, please let us continue the discussion in one of both threads, in order to keep a better track on the exchanged information.
Thank you for your understanding.
Regards,
Stef
Progress Telerik