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:
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
bootzilla
Member
137 Points
597 Posts
Formatting currency problem
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.
dhol.gaurav
Contributor
3998 Points
725 Posts
Re: Formatting currency problem
Nov 17, 2012 09:50 AM|LINK
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
Gaurav Dhol
Skype ID : dhol.gaurav
If My Post contains helped you, Please Mark as Answer
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: Formatting currency problem
Nov 19, 2012 04:49 AM|LINK
try below:
FormatNumber(Fields!yourAmountToConvert.Value,2)
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
jeeveshfulor...
Participant
1562 Points
287 Posts
Re: Formatting currency problem
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.