Parameter validation error and warning messages?

Arif shah · August 5, 2014

Hi,
 
I have a report that has a start and end date parameter. I want to do the following validations
 
1) If start date is null and end date is some selected date ( or otherwise), show error message that either both should be nulls or both should be a selected date..(in case of start date and end date null, all dates will be selected, otherwise show data between start and end date)
 
2) If end date is less than start date, show an error message
 
Can someon please help me do this validation for start and end date parameters
 
Arif

GLO_FR · August 6, 2014

Hi, 
 
you have to build a custom parameter page.
This kind of test are not possible with the default one.

Mihai Nicoara · July 30, 2020

Hi,
Is there a change here since 2014? I need to validate the parameters , and the concept of "out of the box" report parameter fails if I cant do a simple custom validation. Is there a place I can write my cusom javascript for the parameter screen ?

jfranken · July 30, 2020

Hi Mihai,

If you select the parameter in the Data Explorer pane and then select the Script tab at the bottom of the Layout pane, you will see several events. One of them is called "Validate". You can write JavaScript code that evaluates to Boolean true or false in the Validate event as shown in the attached example. If you run the sample report and enter a parameter value greater than 112, the parameter will be rejected. Your Validate script can contain any JavaScript code to do the validation.

It is not possible to control the error message. Add clear instructions in the parameter editor help so that users know why values are invalid. As was mentioned in the old posts, you can create your own parameter page (typically an HTML form) if the built in functionality does not meet your requirements.

Parameter validation error and warning messages?

Comments

Categories