Custom format for numeric data

Hi,

We want to use thousand separators but doesnt want to limit the number of digits after decimal.
Using fixed format thenumber of digits after decimal is also fixed.
We want to show whatever is stored in database it can be 2 , 3 ,4 and so on number of digits after decimal.
Can we achieve that ?

Thanks

Find more posts tagged with

Comments

Manilal

Hi Birtrac,

I have a similar requirement. If you have got some solution please share the same...

Thanks in advance,
Manilal

mwilliams

Manilal,

It looks like BIRT limits the size of a numerical field to like 17 digits and possibly a limit on decimal places of like 14, so you could set up a "custom" code for your decimal field with something like:

#,###.################

This would display up to 17 digits with no limit past the decimal unless you reach the size limit for the field. If there is a limit on decimal places in BIRT, you may not need all of those, but it won't hurt anything.

Hope this helps.