Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Be wary of people who tell you how honest they are
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How Do I Display Zeros instead of Blanks in a Matrix in SSRS 2008?

During a recent SQL Server Reporting Services 2008 report writing project, the client wanted all the spaces of the matrix, to be replaced with zeros.


To solve this problem, the following expression was added to the Data section of the matrix:

= IIF(IsNothing (Sum(Fields!Fieldname.Value)) , 0, Sum(Fields!Fieldname.Value))

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


Name *

Email Address *

Comment *

To prove you are human what is:

7 + 71 =