CUIC / Report Definition / Fields Custom Format

[muratozbek]

Hi,

As you know, we can format fields from Report Definition. The standart decimal point format for representig the tenths and hundredths is dot(.)

However, we want to use comma (,)  for decimal point. I try to create my custom format from as 12345,6789 but it does not work.

Is there any way that comma (,) can be used as decimal point.

Any help will be appreciated.

Murat

[Edward Umansky]

Doesn't look like that is one of the options. You would probably need to do your formatting directly in SQL.

[victor.ortizDD]

Hi,

As I am facing the same issue. Did you a possibility  to change that on the cuic or did made a Change finally on the SQL part ?

Many thanks for your help.

[victor.ortizDD]

Hi to all ,

ok so the only possibility would be to cast the value into nvarchar and replace  the dot into comma.

replace(cast(value_as_decimal as nvarchar(10)),'.',',')

If someone else has another possibility that would be great to share with us.

Thanks in advance