Display Blanks Instead of <N/A> on Reports

boyergary · September 23, 2019, 5:48pm

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?

KathyApplebaum · September 23, 2019, 6:12pm

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)

osolorzano · September 23, 2019, 6:22pm

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.

boyergary · September 23, 2019, 6:47pm

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!