# Passing Null values to Report Viewer

**URL:** <https://forum.inductiveautomation.com/t/passing-null-values-to-report-viewer/114424>\
**Category:** Ignition\
**Tags:** ignition81, reporting\
**Created:** [March 10, 2026, 8:22pm UTC](https://forum.inductiveautomation.com/t/passing-null-values-to-report-viewer/114424 "2026-03-10T20:22:04Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ron.deavers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ron.deavers/32/82978_2.png) [@ron.deavers](https://forum.inductiveautomation.com/u/ron.deavers)\
**Post date:** [March 10, 2026, 8:22pm UTC](https://forum.inductiveautomation.com/t/passing-null-values-to-report-viewer/114424/1 "2026-03-10T20:22:04Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 10, 2026, 8:39pm UTC](https://forum.inductiveautomation.com/t/passing-null-values-to-report-viewer/114424/2 "2026-03-10T20:39:32Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ron.deavers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ron.deavers/32/82978_2.png) [@ron.deavers](https://forum.inductiveautomation.com/u/ron.deavers)\
**Post date:** [March 11, 2026, 12:51pm UTC](https://forum.inductiveautomation.com/t/passing-null-values-to-report-viewer/114424/3 "2026-03-11T12:51:46Z")

</div>

My parameters are added by python scripting. This option would require me to rewrite the script but I’ll look into this. Thank you.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 11, 2026, 1:02pm UTC](https://forum.inductiveautomation.com/t/passing-null-values-to-report-viewer/114424/4 "2026-03-11T13:02:23Z")

</div>

> [@ron.deavers](#):
>
> My parameters are added by python scripting.

~~Then just have the script omit nulls from the parameter dictionary.~~

I don't think you will ever fix this. Null is the actual signal to use the report default.

Make the report default to null instead.

---

<div class="post-metadata">

**Author:** ![ron.deavers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ron.deavers/32/82978_2.png) [@ron.deavers](https://forum.inductiveautomation.com/u/ron.deavers)\
**Post date:** [March 11, 2026, 1:13pm UTC](https://forum.inductiveautomation.com/t/passing-null-values-to-report-viewer/114424/5 "2026-03-11T13:13:42Z")

</div>

I get this whenever I put Null, None or any other variation of null in the Default Value.

![Screenshot 2026-03-11 091140](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/c/cca04371c06630d663e87c95b1175bcd9eaffdf3.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 11, 2026, 1:47pm UTC](https://forum.inductiveautomation.com/t/passing-null-values-to-report-viewer/114424/6 "2026-03-11T13:47:26Z")

</div>

Perhaps it is time to make a formal feature request.

---

<div class="post-metadata">

**Author:** ![ron.deavers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ron.deavers/32/82978_2.png) [@ron.deavers](https://forum.inductiveautomation.com/u/ron.deavers)\
**Post date:** [March 27, 2026, 12:38pm UTC](https://forum.inductiveautomation.com/t/passing-null-values-to-report-viewer/114424/7 "2026-03-27T12:38:29Z")

</div>

> **[Report Builder to accept NULL parameters | Ignition Features and Ideas |...](https://ideas.inductiveautomation.com/ignition-features-and-ideas/p/report-builder-to-accept-null-parameters)**
>
> When building a report, if you put NULL as a Default Value for a parameter or pass NULL to a parameter at runtime, errors will appear in the log.
