Count expression SSRS Report

reporting-services count expression ssrs-expression
Jt2ouan picture Jt2ouan · Mar 4, 2013 · Viewed 54.9k times · Source

Trying to count all rows in a column where column=Yes I have two columns in my report Accepted and rejected.

I'm trying to count the rows where accepted=Yes and do the say thing for rejected.

I've tried these:

=COUNT(IIF(Fields!accepted.Value="Y",1,0))
=COUNT(IIF(Fields!rejected.Value="Y",1,0))   
=COUNT(FIELDS!accepted.value="Y")
=COUNT(FIELDS!rejected.value="Y")

this expression is counting every row as opposed to just the ones that are "Y"

Answer

Tom Jenkin picture Tom Jenkin · Mar 4, 2013

You can do this a couple of ways:

SUM(IIF(Fields!accepted.Value="Y",1,0))

or

COUNT(IIF(Fields!accepted.Value="Y",1,Nothing))

COUNT is a count of all Rows, so even by returning 0 it will get included in the count. This is why returning Nothing should do the trick.

Related questions

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
SQL variable to hold list of integers

I'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One of the parameters the report asks for is a list of integers. This is achieved on the report …

Read More