• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

SQL Reports

I created a basic tabular report in sql server 2008 Business Intelligence Development studio.
I need to display summary information.
I have one column Paid it has values either true or false. I want the row count that has true value for column paid.Basically row count based on column value.
Please give me the expression.

2 Solutions
in the table footer for that column
use the below expression

= Sum (IIF(Fields!Paid.value = "true",1,0))

this should give count of values where paid is true
When you say it has values either true or false, is it a "Bit" data type in SQL which means in SQL it will show as 1 or 0 and in SSRS it will be treated as a Boolean data type and referenced as = True or = False.

If it physically holds the text value "True" or "False" then Suresh's code should work as is.

If not then you need to modify it slightly depending on type.

e.g. For Bit/Boolean types;
     = Sum(IIf(Fields!Paid.Value, 1, 0)
is enough.

KavyaVSAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now