Take the 2-minute tour ×

I have groups with specific filters. Within these groups I have few "Count" expression with conditions. All works great. But when group doesn't have any elements then it disappears. But I need to show in "Count" cells "0" for this group. How can I do this?

share|improve this question
Can you add the SQL query you are using to the question, and indicate which fields you are grouping on? –  Mark Bannister May 1 '12 at 7:30

2 Answers 2

up vote 1 down vote accepted

Here are two suggestions.

In your query use an ISNULL function.

 ISNULL(YourExpression, 0)
 From Table

In SSRS Use an expression for the fields you want to eliminate nulls.

 iif(fields!Field.Value is nothing , 0 , Fields!Field.Value)

Hope this helps :)

share|improve this answer
thanks very much, second way works perfectly! –  Roman Badiornyi May 1 '12 at 13:30

use the below expression:

share|improve this answer

Your Answer


