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

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.
=iif(CountDistinct (Fields!custid.Value) <>1,"transparent","RED")

Open in new window

LP_TechAsked:
Who is Participating?
 
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
CountDistinct is going to Count the Distinct values of All your custid values in the default scope you are in, inner most grouping.  See technet article for how it works, http://technet.microsoft.com/en-us/library/ms155923.aspx.  If you are grouping by custid then this will work as you can use that grouping scope to do the count, but it will not work in just a normal list or table without the group.
0
 
HwkrangerCommented:
Check the scope of what you're doing.  Are the customers in the same scope that you're doing the count distinct in?
0
 
LP_TechAuthor Commented:
There are two row groups. Is this part of the problem?
0
 
LP_TechAuthor Commented:
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?
0
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.

All Courses

From novice to tech pro — start learning today.