Skip to Content
Author's profile photo jaheer ussain babu shajakhan

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

Assigned Tags

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