Discussion 4 Replies 1900 Views × Close popover Vamshi Krishna Kassety (VamshiIPA) IPA Architect IPA AU View Profile Send Message VamshiIPA Member since 2015 16 posts IPA Posted: July 1, 2015 Last activity: July 28, 2015 Posted: 1 Jul 2015 3:42 EDT Last activity: 28 Jul 2015 5:46 EDT 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 Reporting × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × 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 Posted: 1 Jul 2015 8:39 EDT × Close popover Teng Hao Chua (chuat) PEGA Global Tech Enablement, Senior Instructor Pegasystems Inc. SG View Profile Send Message chuat PEGA replied to VamshiIPA Have you tried the "Remove duplicate rows" option in the Query tab of the report definition rule form? Posted: 5 years ago Posted: 2 Jul 2015 1:36 EDT × Close popover Vamshi Krishna Kassety (VamshiIPA) IPA Architect IPA AU View Profile Send Message VamshiIPA IPA replied to VamshiIPA Thanks CHUAT, got it Vamshi Posted: 5 years ago Posted: 16 Jul 2015 4:39 EDT × Close popover Premkumar Ganesan (PremkumarG) cognizant cognizant NL View Profile Send Message PremkumarG cognizant replied to VamshiIPA Hi CHUAT/Vamsi, I dont see the first and second row are duplicate.. Then how come you achieve this.?! Posted: 5 years ago Posted: 28 Jul 2015 5:46 EDT × Close popover Sai Phaneendra (SaiYakkali) Coforge Tech Technical Architech Coforge Tech US View Profile Send Message SaiYakkali Coforge Tech replied to VamshiIPA In this requirement he need only Manager Name, so Remove Duplicate Records will show only unique records.