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
Posted: 5 years ago
Posted: 5 years ago
Thanks CHUAT, got it
Vamshi
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?