How to print thousands separator on a report.

[Former Member]

Hi everybody,

I am trying to print a report with thousands separator but I'm not able to do it.

I tried using the currency addition to the write statement but doesn't work.

Any help will be appreciated.

Orlando.

[suresh_datti]

try this..

data w_amt type p decimals 2 value '100000000.00'.

write w_amt using edit mask '__,___,___.__'.

But the CURRENCY in the write statement should also work. Pl check the decimal notation in your User defaults.

Regards,

Suresh Datti

[Former Member]

Thanks Suresh

I tried that with a value like 1500.00 using a mask like '___,___,___.__' and the result I get was ___,___,500.00 instead of 1,500.00.

I don't know what I'm doing wrong!

[former_member186741]

I think the key is how your variable is declared. If it's type p with decimals 2, the write without any edit mask will give you the correct results.

[Former Member]

Hi ,

Just pass your value to a char field and write that

char field.

For Ex:

data : v_int type i,

v_char(20).

v_int = '12345678'

write v_int to v_char.

write 😕 v_char.

this will give U 12,345,678

Regards,

GSR.

[Former Member]

hai,

just try out this,

REPORT Zxxx.

DATA number TYPE p VALUE '-1234567.89' DECIMALS 2.

WRITE: 'Number', number.

hope this may help you.

regards,

prema.A

Message was edited by: prema a

[Former Member]

Hi orlando,

1. It comes by default.

- thousand separators.

2. just try this.

report abc.

*----

---

data : m type p decimals 2.

m = '1500.66'.

write 😕 m.

m = '765123.66'.

write 😕 m.

m = '9765123.66'.

write 😕 m.

regards,

amit m.