Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Reporting Services

FormatCurrency in 2k5 Report Services

I have a test report, unformatted the value one of my fields is -29.5600

When I apply the format:FormatCurrency(Fields!Paid_Amount.Value)the value shows as -($293056). Another sample is -62.2400 which converts to -($626224).

It seems the leading digits are being repeated for some reason. I've tried playing with rounding, the optional tristate paramaters, and regional settings to get the correct output, but have had no luck. Can anyone be of assistance?

[608 byte] By [Cytosoul] at [2008-2-10]
«« Thread Debugging
»» DataGridView Internal Error when Datasource changes?
# 1
Figured it out. Seems I have to use: "$#,###.##"
Cytosoul at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2
Another way for formatting numeric values is to use .NET formatcodes in the "Format" property of the textbox (Note: the textbox value expression has to evaluate to a numeric value otherwise the format code has no effect).

The format code for currency would be: C

MSDN has additional information about standard and custom format strings for numeric values:
* http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandardnumericformatstrings.asp
* http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp

--Robert

RobertBrucknerMSFT at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
SQL Server
SQL Server Reporting Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified