Creating reports and dashboards | Stimulsoft community forum

Posted: **Thu Jan 15, 2015 12:18 am**

Hi,

I am in SS 2014.3 version and would like to know if the following is possible and if so how to achieve it.

example amount = BHD 1234.456

Should be converted to "One thousand two hundred and thirty four & 456/1000 Only"

I did try ToCurrencyWords(1234.456, true, true, "Dinnar/Dinnar","Fills/Fills") and then it gets converted as "ONE THOUSAND TWO HUNDRED AND THIRTY-FOUR DINNAR AND FORTY-FIVE FILLS"

Thanks

Posted: **Thu Jan 15, 2015 10:37 am**

Hello,

Please try to use the following expression:

Code: Select all

{ToWords((int)var) + " & " + Math.Round((var - (int)var) * 1000, 0) + "/1000 Only"}

where var is your value, for example variable or datasource field.

Thank you.

Posted: **Thu Jan 15, 2015 11:34 pm**

Thanks Ivan, it did work.

Posted: **Fri Jan 16, 2015 4:30 am**

Great!

Have a nice day!

Creating reports and dashboards | Stimulsoft community forum

tocurrencywords to convert amount to words

tocurrencywords to convert amount to words

Re: tocurrencywords to convert amount to words

Re: tocurrencywords to convert amount to words

Re: tocurrencywords to convert amount to words