how to fill a field with leading zeros

miguels · Post by **miguels** » Wed Feb 01, 2012 3:45 pm

hello I have a label which paints a numeric field in my data source, and I need to put them zeros in my report

example, my field in the data source 250 ok and I have in my report I need it so .. 000520 but the length must be 6 digits independent of the length of the field filled with zeros ..

is put in sql rigth ('00000 ', employee, 6) as employed but do not want to put in my data source if or paint my tag on my report, I hope you can

Post by **HighAley** » Thu Feb 02, 2012 7:06 am

Hello.

miguels wrote:hello I have a label which paints a numeric field in my data source, and I need to put them zeros in my report

example, my field in the data source 250 ok and I have in my report I need it so .. 000520 but the length must be 6 digits independent of the length of the field filled with zeros ..

is put in sql rigth ('00000 ', employee, 6) as employed but do not want to put in my data source if or paint my tag on my report, I hope you can

If I clearly understood you, you could set the text Format of the Text box to the Custom and set it to "000000".

Thank you.

miguels · Post by **miguels** » Thu Feb 02, 2012 3:05 pm

ok I need is forgiveness.

in a text box in a writing sample 250 and pass that value to a label in my report but I need a length of 6 characters filled with zeros, well in my report, I must leave 000250

and what I find is like putting those zeros to get the textbox value

Post by **HighAley** » Fri Feb 03, 2012 2:42 am

Hello.

miguels wrote:ok I need is forgiveness.

in a text box in a writing sample 250 and pass that value to a label in my report but I need a length of 6 characters filled with zeros, well in my report, I must leave 000250

and what I find is like putting those zeros to get the textbox value

Did you set the Format property of the Text box?

Thank you.

fsimon · Post by **fsimon** » Thu Oct 06, 2016 2:47 pm

Hi,

We try to do the following without success.
- put "0000.000" in custom text format property.

We have a number field and we would like to have 4 digits with leading 0 before the decimal
Our field disapears on the display.

What is the correct syntax of the custom property, is there another way to do it (with a toString method ?)

Is this feature available on flex version (2016.1.10) ?

Post by **Alex K.** » Thu Oct 06, 2016 8:06 pm

Hello,

In flex version please try to use the following mask in the Format:
#0000.0000

: Capture1.PNG (54.49 KiB) Viewed 4405 times

: Capture2.PNG (27.39 KiB) Viewed 4405 times

Thank you.