Filters:

  • Technologies

  • Instructors

  • How to Display Blanks as Zeros in a SSRS Report

    Some of the cells in this SSRS matrix report are blank:

    001-How-to-Display-Blanks-as-Zeros-in-a-SSRS-Report

    To display zeros instead, we will use two functions:

    1.

    2.

     

    In the design of the matrix, right-click on the textbox containing the values in question, then select Expression… to edit the expression underlying the textbox.

    002-How-to-Display-Blanks-as-Zeros-in-a-SSRS-Report

    Type the following expression in the Expression dialog:

    003-How-to-Display-Blanks-as-Zeros-in-a-SSRS-Report

    The expression says that if SUM(Fields!SubTotal.Value) is Null (the IsNothing() function that it is in returns a True if it is Null and a Fales if it isn’t), then a zero is returned by the expression; otherwise the SUM(Fields!SubTotal.Value) is used.

    You may also like:  How to Display the Elapsed Processing Time of a Report in SSRS

    Click OK and preview the report again. Notice that zeros are now present in what used to be the blank cells.

    004-How-to-Display-Blanks-as-Zeros-in-a-SSRS-Report

    Enjoy!

    Peter Avila
    SQL Server Instructor – Interface Technical Training
    Phoenix, AZ

    See what people are saying...

    1. sivakumar

      i used above code its working …
      But its displaying only one zero ,i need 0.00 like this

    Share your thoughts...

    Please fill out the comment form below to post a reply.