<div>
Phillip Burton<br />
I was not looking for sum. it was more about counting.<br />
I resolved and delete this question.<br />
thanks for your help
</div>


<div>
I've requested that this question be deleted for the following reason:<br />
<br />
questioning about 'counting records and not summing up.
</div>


<div>
My solution was about counting - it said that if the value was equal to 2, then &quot;Sum 1&quot;, which is the equivalent of &quot;counting&quot;.<br />
<br />
If you have resolved this issue, what was your answer please.
</div>


<div>
<div class="content wysiwyg-content">
Hi, <br />
I have a column that returns either 1,2 for active and inactive records.<br />
<br />
I like to have two fields, one calculate total number of records returning 1 and another display total number of records returning 2.<br />
<br />
Thanks
</div>
</div>


Hi, 
I have a column that returns either 1,2 for active and inactive records.

I like to have two fields, one calculate total number of records returning 1 and another display total number of records returning 2.

Thanks

SSRS 2008  expression in report to count values

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.