Thousand Separator problem

[sravanthi]

While using crystal reports (v 9.0) we are not able to display the numeric fields with the 1000 seperator (comma) in Indian format.
It is using the US style of million separator even if we set it in Indian style in the Control Panel Regional settings.
Is there a simple way to convert it to Indian style.

[tks_muthu]

Create a formula having this code

StringVar Amt;
StringVar s;
NumberVar N;
Amt:=Replace(Totext({AmountField}),",","");
s:=left(Amt,len(Amt)-3);
N:=len(s);
Select N
case 4:
left(s,1)&","& right(s,3) & ".00"
case 5:
left(s,2)&","& right(s,3)& ".00"
case 6:
left(s,1)&","& mid(s,2,2) & "," & right(s,3)& ".00"
case 7:
left(s,2)&","& mid(s,3,2) & "," & right(s,3)& ".00"
case 8:
left(s,1)&","& mid(s,3,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
case 9:
left(s,2)&","& mid(s,3,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
default:
s;


and place it in the details section

[sraheem]

Hi
Muthu i works well, but summary function sum cannot be used as output is a string, even Val function stops at first comma.

[sravanthi]

Thank You!
It is a good solution, but I am looking for some general solution - like changing the registry or regional settings.
Since we have about 60 reports, all of them fully developed, it is difficult to write formula in each and every report. Moreover in each report we are having 4 to five numeric value columns or some times more than that. So I am not sure that, if we add formulae for each and every column , how the performance of the report would be affected!?!

[rienza]

hye gys...anybody can help me...:(

examlpe my code:

"LMB/"&ToText(truncate(tonumber({dsKertasLMB_B.BilMesyuarat}),0),0)&"/"& totext((year({dsKertasLMB_B.Tahun})),0)&"(B)"


the result:
LMB/101/2,007(B)


i need to remove the saparete thousand so that the result like this:LMB/101/2007(B)

tq