Geek asks and answers

SSRS Reports, Group Filtering

I have groups with certain filters. Inside these groups, I have several "Count" expressions with conditions. Everything works great. But when a group has no elements, it disappears. But I need to show in the cells "Count" "0" for this group. How can i do this?

+3
source share
2 answers

Here are two suggestions.

Your request uses the ISNULL function.

 Select
 ISNULL(YourExpression, 0)
 From Table

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

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

Hope this helps :)

+1
source

use the following expression:

=iif(isnothing(Field!Name.value),0,count(Field!Name.value))
0
source

More articles:


All Articles