I have a report where one of the columns can be either text and/or numbers. Sometimes it is all numbers with leading zeros.
It is a flat format report and I am using version 18.104.22.168 of Flexmonster.
When the column is all numbers it treats it as the default number format and loses the leading zeros.
Example data is
The Flat report shows:
ABCD 123 456 789
EFGH 987 654 321
If I use the filter for Column_2 it shows the values without the spaces and with the leading zeros.
I need the report to show the values as they are in the data (i.e. with leading zeros and without the thousand space separator).
The JSON saved via Flemonster is attached – I have changed the filelocation only.
You can override the default number format and set the necessary values here. For more details, refer to this article: https://www.flexmonster.com/doc/number-formatting/#!default
By the way, a lot of useful information can be found in our docs section: https://www.flexmonster.com/doc/