Home Forums Reporting Services Reporting Services 2005 Development Numeric Formatting - Display Zero as Dash? RE: Numeric Formatting - Display Zero as Dash?

  • May 12, 2011 at 10:41 pm

    #1324081

    Daniel Bowlin (5/12/2011)

    2008 has a - for a 0 built in. When I choose it the expression it creates is:

    0.00;(0.00);'-'

    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.

    Thanks again,

    Pete