• Technologies

  • Instructors

  • How to Display Blanks as Zeros in a SSRS Report

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


    To display zeros instead, we will use two functions:




    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.


    Type the following expression in the Expression dialog:


    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.



    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.