CODEWITHSUNDEEP
sqlreporting-servicesbusiness-intelligence
Roman Badiornyi
Roman Badiornyi

Reputation: 1539

SSRS Reports, Group filtering

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?

Upvotes: 3

Views: 1263

Answers (2)

NebDaMin
NebDaMin

Reputation: 658

Here are two suggestions.

In your query use an ISNULL function.

 Select
 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 :)

Upvotes: 2

hemanth
hemanth

Reputation: 587

use the below expression:

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

Upvotes: 0

Related Questions