# Display Blanks Instead of \<N/A\> on Reports

**URL:** <https://forum.inductiveautomation.com/t/display-blanks-instead-of-n-a-on-reports/28474>\
**Category:** Ignition\
**Created:** [September 23, 2019, 5:48pm UTC](https://forum.inductiveautomation.com/t/display-blanks-instead-of-n-a-on-reports/28474 "2019-09-23T17:48:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![boyergary](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/boyergary/32/10316_2.png) [@boyergary](https://forum.inductiveautomation.com/u/boyergary)\
**Post date:** [September 23, 2019, 5:48pm UTC](https://forum.inductiveautomation.com/t/display-blanks-instead-of-n-a-on-reports/28474/1 "2019-09-23T17:48:26Z")

</div>

There’s probably a very simple answer to this which I can’t find, but how can I stop displaying \<N/A\> in report fields that are empty and just display a blank instead?

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [September 23, 2019, 6:12pm UTC](https://forum.inductiveautomation.com/t/display-blanks-instead-of-n-a-on-reports/28474/2 "2019-09-23T18:12:38Z")

</div>

What version are you using? In 8.0.2 we fixed the issue of your deletion of “N/A” not sticking. (Note to self: FB11351 in case I need to find the fix)

---

<div class="post-metadata">

**Author:** ![osolorzano](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/osolorzano/32/6432_2.png) [@osolorzano](https://forum.inductiveautomation.com/u/osolorzano)\
**Post date:** [September 23, 2019, 6:22pm UTC](https://forum.inductiveautomation.com/t/display-blanks-instead-of-n-a-on-reports/28474/3 "2019-09-23T18:22:23Z")

</div>

![nullFormat](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/78c83a299e8a8e5e0c59f1046dc07cc4f3a277eb.png)  
If by chance you are just looking for _where_ this is set. You want to select the key on the component that is displaying the value. This will open the property editor for that key and from there you can set the Null Format to a blank.

---

<div class="post-metadata">

**Author:** ![boyergary](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/boyergary/32/10316_2.png) [@boyergary](https://forum.inductiveautomation.com/u/boyergary)\
**Post date:** [September 23, 2019, 6:47pm UTC](https://forum.inductiveautomation.com/t/display-blanks-instead-of-n-a-on-reports/28474/4 "2019-09-23T18:47:37Z")

</div>

Yup, that’s where it is! 😉

Thanks a bunch. I looked for that for a while but must have missed it.

EDIT: FYI, if you just get rid of the \<N/A\> in the field, it still displays on the report. I had to change it to a single space to get rid of the \<N/A\>. This may be what Kathy was talking about in the first reply. Thanks!
