How to use the Thousand Seperators In Crystal Report 8.5

Hi!

I am developing a accounting application using visual basic and ms access.
then i use the crystal report 8.5 for report.

plz explain how to use the thousand seperator formula in number field.

like Rs.5,55,555.00

when i applied the thousand seperator formula

it should be displayed like this :

Rs 55,555,55.00

what can i do for these problem plz explain.

then one more doubt is there :

how to use the crystal report in asp page.

plz have u got any source plz send me.

thanks in advance.What is your desired output?
Rs 55,555,55.00 or 5,55,555.00?|||hi mathivanan!

i like the following format

indian currency format

Rs : 5,55,55,555.00

plz explain|||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|||hi mathi!

when i am using the formula!
i got the error message

"The Formula Result Must be a Boolean"
here u also use ToText Function but its fired error.

what can i do for these problem plz explain.

StringVar Amt;
StringVar s;
NumberVar N;

Amt:=Replace(Totext({product_details.prod_price}),",","");
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;|||It should work correctly
Check again whether you miss something in the code|||Hi MathiVanan!

your code is working properly!

thanking you.|||Well
How did you have problem initially?|||Hi Mathy!

actually i am applying the function to the price field object using

Field Object --> Format -->Number Format-->
Thousand Seperator -->Choose the Formula Editor

later i just create a new formula field and applying this code.
and then drag the formula field in my report page
it working properly.

thanks mathi!

muthu