Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

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

0
LP_Tech
Asked:
LP_Tech
  • 2
1 Solution
 
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
 
Chris LuttrellSenior 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
 
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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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