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.