Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 19, 2012 08:38 AM by jeeveshfuloria08
Nov 16, 2012 09:02 PM|LINK
Currently I'm formatting the current on a field and when I look at the report the amounts that have an actual cent ex. 449.91 they show on the report as 449.91 but the amounts that don't have a cent ex. $1369.00 it shows on the report as $1369. Can someone
help me to figure out a way so that when an amount that has .00 to show on the report as 1369.00 instead of 1369. THis is what I have for the expression:
=Format(Round(Fields!TcAmtTemp.Value, Fields!CurrencyPlaces.Value), Fields!CurrencyFormat.Value)
and I have N2 for the Custom format.
Nov 17, 2012 09:50 AM|LINK
Check below link it may help you
let me know if any query
Nov 19, 2012 04:49 AM|LINK
Nov 19, 2012 08:38 AM|LINK
Right click on field/Cell go to text box properties :- select Number :- select Currency from the Category on left panel :-
On right panel set few properties.
1. Decimal places : 2
2. Negative numbers : ($12345.00)
3. Symbol : $ English (United States)
I hope this will work.