Selective Count in Reporting Services Report field

• Ronald R Mayfield

  SSC-Addicted

  Points: 446

  More actions

  November 6, 2007 at 11:29 am

  #153939

  I am using SQL 2005 reporting services.

  I have a report that displays a number of records. One of the fields returned is yes or no. I would like to display the count of yes in one text box and the percentage of yes fields returned in another text box. I think there is a way to do this using an iff statement, but I can't get it to work.

  I am pretty new to the SQL reporting services, if anyone can offer some help, it would be greatly appreciated.

• Ronald R Mayfield

  SSC-Addicted

  Points: 446

  More actions

  November 6, 2007 at 12:45 pm

  #748812

  I found one possible solution to my issues as shown below:

  =sum(iif(fields!InSpec.Value ="Yes",0,1))

  and for the percentage

  =sum(iif(fields!InSpec.Value ="Yes",1,0))/count(fields!InSpec.Value)