Numbers with Leading Zeros

Hi,
 
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 2.3.1.1 of Flexmonster.
 
When the column is all numbers it treats it as the default number format and loses the leading zeros.
 
Example data is
Column_1 Column_2
ABCD       000123456789
EFGH        000987654321
 
The Flat report shows:
Column_1 Column_2
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.
 
Regards,
Paul

2 answers

Public
Tanya Gryshko Flexmonster October 11, 2018

Hello, Paul,
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/
Regards,
Tanya

Public
Paul Young October 11, 2018

Tanya,
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.
 
Regards,
Paul

Please login or Register to Submit Answer