How do I get Indian style comma in Currecny ?
Indian style comma in Currency as against Normal style goes like this :
Normal Style
1,234
123,456
12,345,678
1,234,567,890
Indian Style
1,234
1,23,456
1,23,45,678
1,23,45,67,890
Typically after thousand, we have comma after every two digits (against 3 digits of common style).
How can I achieve this with Fast Report ?
TIA
Milan.
Normal Style
1,234
123,456
12,345,678
1,234,567,890
Indian Style
1,234
1,23,456
1,23,45,678
1,23,45,67,890
Typically after thousand, we have comma after every two digits (against 3 digits of common style).
How can I achieve this with Fast Report ?
TIA
Milan.
Comments
Can you guide us more on the subject ?
Where can I find information about float function ? I am using FR for Xailer.
What should be the formatting string ?
TIA
Milan.
I checked in the Delphi and C++ help and all separators before the decimal point are referred to as thousand separators. There does not seem to be any support for what you want.
What I wonder though is whether Windows itself allows your format to be set up under Regional Settings when India is set as location.
Yes, windows allow this setting.
I use Windows 8 and I can set the same in Regional Settings -> Currency -> Digit grouping as 12,34,56,789.
Can that be of any help to us in FR ?
TIA
Milan.
Help will be highly appreciated as this is a burning issue for us.
TIA
Milan.
IIRC there is a CurrencyFormat property there.
Then use the same formatting string in the FR component.
If it does not work it is time to write a ticket for FR support to look into it.
FR should handle everything supported by Windows.
I am actually surprised that leaving the formatting string blank in a number field does not automatically default to the Windows setting but leaves the field blank altogether.
Can someone help me write a function to achieve this ?
Can this function be called in OBP Event of the object ?
TIA
Milan.
Hi.
This pascal function seems to work:
The function can be used in your memo: [IndianFormat('123456789')]
Petter