I have a column of dollars for an invoice. For example: Order Total: $12.00 Discount: $1.00 Sub-Total: $11.00 Tax: $1.00 Total: $12.00 Payments: $5.00 Balance Due: $7.00 My client wants the "Payments" to be displayed like ($5.00). My problem is the Amount column is a giant union in SQL of 15 - 20 conditions and when the payments are being gathered the SUM of the payments is a positve number. How can I format the field in SSRS 2005 to display brackets indicating its a negative currency like its doing for the other Discount which is a negative number in the Union? =Fields!Amount.ValueChris

Maybe you can do an additional update at the end or maybe you can add logic for * -1 and then put a case statement around the value when its negative

Hi, 1) Right click the textbox, select property. 2) Click "Format" TAB. 3) Format code: ###0.00;(###0.00) Regards, PS

Hi, You could right click on the text box where you are showing the payments value and select "Text Box Properties". In that you could select the Format and specify it as a currency. Also there is an option of showing negative currency in braces. HTH, Ram

Hi Chris, As Pritam and Ram suggested, we can set the Format property of the textbox to achieve the requirement. In addition, I would also recommend you refer to the Example section in the article User-Defined Numeric Formats at http://msdn.microsoft.com/en-us/library/4fb56f4y.aspx Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.