Skip to Content

Displaying Currency in Indian Numbering Format

Crystal report Sometimes We need to show Values fields as Custom Currency format, in that Situation

right click on the field you want to change and go to format field ,in a Common Tab- Display String write a formula

    TOTEXT(CURRENTFIELDVALUE,”#,##,##,##,##0.00″)

For Multiple Currencies Please use if condition

       If Currency=”INR” THEN TOTEXT(CURRENTFIELDVALUE,”#,##,##,##,##0.00″) ELSE

TOTEXT(CURRENTFIELDVALUE,2)

Thanks&Regards

S.Jaheer Ussain Babu

Be the first to leave a comment
You must be Logged on to comment or reply to a post.