Formatting currency problem

Question

User-501297529 posted

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.

Answer 1

User477186420 posted

Hey,

Check below link it may help you

http://www.sqlservercentral.com/Forums/Topic576286-1063-2.aspx#bm1200861

http://stackoverflow.com/questions/922506/what-are-the-valid-style-format-strings-for-a-reporting-services-ssrs-expressi

let me know if any query

Answer 2

User2105670541 posted

try below:

FormatNumber(Fields!yourAmountToConvert.Value,2)

Answer 3

User-1051986203 posted

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.