Passing Null values to Report Viewer

Ignition
,
1

I have a Report Viewer that takes optional parameters based on user input. If a value is not entered, I want to pass a null value to that parameter in the Report Viewer’s props.params. However, when I do this, I get a warning: ‘Error executing query parameter expression “{paramName}”’

If I leave out the parameter, It will take the default value in the report. If I put a null or None value as the default, I get the same error in the Report Designer.

I’ve tried null, Null, and None.

2

Try an expression binding with the expression null.

If you just write null into the JSON editor, you're creating a string value "null", not an actual absence-of-value.