Okay, so I have a report that shows a difference. I need it to display positive numbers "normally", but using commas and no decimals, and negative numbers using parenthesis: Postitive = 1,234 Negative = (1,234) I used the format code #,#;(#,#) which I modified from the one found here: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/044500ca-534b-4b48-9f0f-70c6594fef16. It works great, unless the result is zero, in which case the number does not display. So, I tried =iif(Fields!SunManifest.Value - Fields!Sun.Value >= 0,"N","(#,#)") and =iif(Fields!SunManifest.Value - Fields!Sun.Value >= 0,"#,#","(#,#)"), taken from here: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/d77014ce-f31a-448c-8409-4c2488c5d36f. I essentially got the same result. And THEN I tried using 0,0;(#,#), which displays the zero, but also displays the number 1 (and other single digit numbers) as 01. So, does anyone know what I have to do to get the report to display whole numbers, with negatives shown in (), and also display 0 if the result is 0?

Okay, so a little more tinkering and I was able to come up with: #,0;(#,#) Which works perfectly. And then I was testing the report against the old one (migrating reports to SSRS from Crystal) and noticed that if the result is zero, all of the pertinent columns are hidden. Go figure. Thanks anyway :)