Page 1 of 1
how to fill a field with leading zeros
Posted: Wed Feb 01, 2012 3:45 pm
by miguels
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
how to fill a field with leading zeros
Posted: Thu Feb 02, 2012 7:06 am
by HighAley
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.
how to fill a field with leading zeros
Posted: Thu Feb 02, 2012 3:05 pm
by miguels
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
how to fill a field with leading zeros
Posted: Fri Feb 03, 2012 2:42 am
by HighAley
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.
Re: how to fill a field with leading zeros
Posted: Thu Oct 06, 2016 2:47 pm
by fsimon
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) ?
Re: how to fill a field with leading zeros
Posted: Thu Oct 06, 2016 8:06 pm
by Alex K.
Hello,
In flex version please try to use the following mask in the Format:
#0000.0000
- Capture1.PNG (54.49 KiB) Viewed 4406 times
- Capture2.PNG (27.39 KiB) Viewed 4406 times
Thank you.