We are using the Report Designer (standalone) tool and have noticed that our report parameters requiring a single value come up with an error message as soon as the report loads as if it is attempting to run without first allowing the user to input a value.
"Missing or invalid parameter value. Please input valid data for all parameters."
I have read through documentation which seems to indicate that as long as a default value is not being provided then it should not try to execute. An example parameter and its propertiers is below:
*******************************
AllowBlank = False
AllowNull = False
AutoRefresh = False
AvailableValues = (none)
Mergeable = True
MultiValue = False
Name = dt_datetime_start
Text = Datetime Start
Type = DateTime
Value =
Visible = True
*******************************
As you can see, there is nothing defined in the Value field, yet the report tries to execute as soon as it is loaded, giving an error that this field is not populated. I have found other references about custom JavaScript that can be put in, but this was unsuccessful.
I'd like to know within the standalone Report Designer tool, how we can ensure that the report does not execute before the user has a chance to enter values.
1 Answer, 1 is accepted
The report will always execute when it is shown in the viewer / previewed in the report designer. There is no such behavior which will not execute a report if the default value is not provided.
You need to either make all parameters optional (AllowBlank, AllowNull equal to True), or create your own custom parameters area and control when the report is assigned to the report viewer within your application.
Regards,
Nasko
Telerik