Discussion4Replies1751Views×Close popoverVamshi Krishna Kassety (VamshiIPA) IPA Architect IPA AU View Profile VamshiIPA Member since 2015 16 posts IPA Posted: July 1, 2015Last activity: July 28, 2015Posted: 1 Jul 2015 3:42 EDTLast activity: 28 Jul 2015 5:46 EDT Closed Get Unique resultsHi All, I want to have a RD which would return me list of unique Manager Names from Emp table. Here is the Table EMPEmp Name || Emp Age || EMP ManagerABC || 22 || XYZSDF || 22 || XYZQWE || 22 || EDFRD Should return XYZEDFCan we do this in RD? Thanks in advance Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post 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 agoPosted: 1 Jul 2015 8:39 EDT×Close popoverTeng Hao Chua (chuat) PEGA Senior Instructor Pegasystems Inc. SG View Profilechuat PEGA replied to VamshiIPAHave you tried the "Remove duplicate rows" option in the Query tab of the report definition rule form? Posted: 5 years agoPosted: 2 Jul 2015 1:36 EDT×Close popoverVamshi Krishna Kassety (VamshiIPA) IPA Architect IPA AU View ProfileVamshiIPA IPA replied to VamshiIPAThanks CHUAT, got it Vamshi Posted: 5 years agoPosted: 16 Jul 2015 4:39 EDT×Close popoverPremkumar Ganesan (PremkumarG) cognizant cognizant NL View ProfilePremkumarG cognizant replied to VamshiIPAHi CHUAT/Vamsi, I dont see the first and second row are duplicate.. Then how come you achieve this.?! Posted: 5 years agoPosted: 28 Jul 2015 5:46 EDT×Close popoverSai Phaneendra (Sai_INCESSANT) Incessant Technologies Pvt Ltd Incessant Technologies Pvt Ltd US View ProfileSai_INCESSANT Incessant Technologies Pvt Ltd replied to VamshiIPAIn this requirement he need only Manager Name, so Remove Duplicate Records will show only unique records.