I have a Base column of type INTEGER. What do I need to do in a report so that a value of 0 displays as “0” rather than blank? (Values of 1, 2, 3, … work as expected.)
I’m sure it is documented somewhere but I have not been able to find it.
Thanks,
Charles
Is it really ‘0’ in datasource? Or is it an empty field, NULL. Have a look here: Base Guide 7.3, Reports → Data Properties
And if Robert is right, you can use functions like
IFNULL(column, 0) or
COALESCE(column, 0) to replace the value in your SELECT-statement.
Thanks.
I am new at this and there are a lot of things I don’t know but I do understand the difference between 0 and null. The field is really 0. If I display the table in columnar format I see a zero, not an empty rectangle.
The relevant characteristics of the column are AutoValue No, Entry required No, Length 10, Default value 1, Format Number General (I have tried Number -12345 but it does not “stick” – it reverts to Number General), Decimal places null, Leading zeroes 1, Negative numbers red No, Thousands separator No, Format Code General.
In the Query that drives the report, nothing special, just “Lunch_Count” FROM “Clients”.
In the report, the field type is Field or Formula and that’s it.
If you don’t recognize the issue then I am mystified.
CM
Have tested with an integer field. Will be shown empty in a report. Then changed the properties for the field from default to 0. Then it will show 0 for value 0 and nothing for NULL.
The field in the table or the field in the report?
Which property?
CM
Click on the field in the report. On the right, last row in the properties, there will be shown the format. Click on the button with … and you will get the possibilities to format the field.
Got it. Changed it from 12345 to 0 and that solved it.
Thanks,
CM
