Solved

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

Posted on 2009-05-12
4
427 Views
Last Modified: 2012-06-22
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
Comment
Question by:LP_Tech
  • 2
4 Comments
 
LVL 9

Expert Comment

by:Hwkranger
ID: 24368547
Check the scope of what you're doing.  Are the customers in the same scope that you're doing the count distinct in?
0
 

Author Comment

by:LP_Tech
ID: 24368627
There are two row groups. Is this part of the problem?
0
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 500 total points
ID: 24371876
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
 

Author Comment

by:LP_Tech
ID: 24374682
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now