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/
Thank you for your reply.
Unfortunately it is not a measure. It is either a row or column which can contain any alphanumeric values.
I have tried using the measure format and can define the thousand separator appropriately but cannot maintain the leading zeros.
In this situation, where I have the issue, it is all numeric with leading zeros. It needs to be treated as a string and the actual value displayed.
I have tried searching your documents and forums for the solutions but have been unable to find one.