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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply