Daniel Bowlin (5/12/2011)
2008 has a - for a 0 built in. When I choose it the expression it creates is:
Try putting that in your format.
Daniel -- thanks for checking SSRS 2008. That format code works. Ironically, as I was saving the formatting expression in a plain ol' text file within my "SSRS bag of tricks" folder, I discovered I had come up with the formatting code a long time ago -- I just didn't label the file very well.
So, I have your format code along with my original one =
Looks like the third segment is what handles zeros.