<div>
Check the scope of what you're doing. &nbsp;Are the customers in the same scope that you're doing the count distinct in?
</div>


Check the scope of what you're doing.  Are the customers in the same scope that you're doing the count distinct in?

<div>
There are two row groups. Is this part of the problem?
</div>


There are two row groups. Is this part of the problem?

<div>
In this case Group one is Product, Group two is Sales Person and then I have my custid field is there any way to identify the duplicate custid's by changing the background color?
</div>


In this case Group one is Product, Group two is Sales Person and then I have my custid field is there any way to identify the duplicate custid's by changing the background color?

<div>
<div class="content wysiwyg-content">
I am trying to identify all non distinct customer id's in a SSRS report by changing the back ground color. The code below only identifies the 1st non unique customer number the first time it is repeated.<br />

<pre><code id="code-320631">=iif(CountDistinct (Fields!custid.Value) &lt;&gt;1,&quot;transparent&quot;,&quot;RED&quot;)
</code></pre>
</div>
</div>


I am trying to identify all non distinct customer id's in a SSRS report by changing the back ground color. The code below only identifies the 1st non unique customer number the first time it is repeated.

How can I identify all non distinct values in a SSRS report?

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.

SSRS

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.