how to find zero value row count in ssrs

Question

0.00/5 (No votes)

See more:

Hi Friends ,

I need find out zero value rows count in ssrs.

for examples,

25
6
0
78
0
5

I need to return 2 .

Regards
Arul

Posted 31-Oct-12 20:11pm

Comments

damodara naidu betha 1-Nov-12 3:10am

Please explain it clearly..

Arul R Ece 1-Nov-12 3:17am

need to find cout of rows .that contains "0" values.

in above example 5 values there.contain 2 zero values.so result is '2'.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2012-11-01T08:03:00

Use a query like this one:

SQL

SELECT COUNT(FieldName) AS [CountOfZeros]
FROM YourTableName
WHERE FieldName = 0

Posted 1-Nov-12 8:03am