Skip to Content
0
Former Member
Oct 24, 2012 at 05:50 AM

How to display decimal digits based on country

15 Views

Hi Every one i have an issue in crystal report.

I need to display decimal digits based on country .

Ex:
kw 1.000
uk 1.00
us 1.0
hk 1.0000

currency Table:

currency id currency code decimal digits currency locale description pattern

1 kw 3 kw kw #0.000

2 Ae 2 Ae Ae #0.00

Like this number of rows there

Country table:

country id currency id country code country name varient language

1 1 kw kuwait us en

Like this number of rows there

can any one please tell me the formua for this