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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 | |
2 |