Formatting Negative Currency

I'm trying to display negative currency in a report as ($3,123), but the best I can do so far is -($3,123). I'm using the following expression to format the textbox.

=iif(Fields!Daily.Value < 0, "($#,##0)", "$#,##0")

Any suggestions

Answer this question

Formatting Negative Currency

theflu
Thanks Brian. Just what I needed.
SW Skeen
Set the textbox to =Fields!Daily.Value. In the properties window for the textbox, on the format tab, set the format code to "C0". The currency format codes are described here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfsystemglobalizationnumberformatinfoclasscurrencynegativepatterntopic.asp
Formatting Negative Currency

Answer this question

Formatting Negative Currency

Hot Topic

Visual Studio

Formatting Negative Currency

Formatting Negative Currency

theflu

SW Skeen