Discussion
4
Replies
1900
Views
Posted: July 1, 2015
Last activity: July 28, 2015
Closed
Get Unique results
Hi All,
I want to have a RD which would return me list of unique Manager Names from Emp table.
Here is the Table EMP
Emp Name || Emp Age || EMP Manager
ABC || 22 || XYZ
SDF || 22 || XYZ
QWE || 22 || EDF
RD Should return
XYZ
EDF
Can we do this in RD?
Thanks in advance
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.
Posted: 5 years ago
Hi CHUAT/Vamsi,
I dont see the first and second row are duplicate.. Then how come you achieve this.?!
Posted: 5 years ago
In this requirement he need only Manager Name, so Remove Duplicate Records will show only unique records.
Have you tried the "Remove duplicate rows" option in the Query tab of the report definition rule form?