Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Commitment is a steely underlying will that endures through all changes in circumstance
 
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!!!!

13
June

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.

Solution:

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

MAKE A COMMENT

Name *

Email Address *

Comment *