How to Display Blanks as Zeros in a SSRS Report

Home > Blogs > SQL Server > How to Display Blanks as Zeros in a SSRS Report

How to Display Blanks as Zeros in a SSRS Report

1 4 Peter Avila
Added by November 12, 2014

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.

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

Videos You May Like

JavaScript for C# Developers – September 24, 2014

0 414 3

In this video Dan Wahlin demonstrate the similarities and differences between C# and JavaScript and the future of JavaScript (ES6).

Subnetting a TCP/IP Network using the Magic Box Method

0 1220 4

In this session, we are going to look at how to subnet a Class B address into multiple network segments using what's called The Magic Box. Let's run through this real quick.

Detailed Forensic Investigation of Malware Infections – April 21, 2015

4 478 3

In this IT Security training video, Security expert Mike Danseglio (CISSP / CEH) will perform several malware investigations including rootkits, botnets, viruses, and browser toolbars.

Write a Comment

See what people are saying...

  1. Avatar Bala Vijaya Kumar

    @ Sivakumar, to display 0.00 you have to change the number format using the Text Box Properties

  2. Avatar Jay

    Works perfectly! To display 2 decimals go to the cell Format property and insert N2.

  3. Avatar Bala

    Still the 0 is not present in my report

  4. Avatar 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.