Discussion

4
Replies
1950
Views
 Vamshi Krishna Kassety (VamshiIPA)
IPA
Architect
IPA
AU
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
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: 6 years ago
Posted: 1 Jul 2015 8:39 EDT
Teng Hao Chua (chuat)
PEGA
Global Tech Enablement, Senior Instructor
Pegasystems Inc.
SG

Have you tried the "Remove duplicate rows" option in the Query tab of the report definition rule form?
Posted: 6 years ago
Posted: 28 Jul 2015 5:46 EDT
Sai Phaneendra (SaiYakkali)
Coforge Tech
Technical Architech
Coforge Tech
US

In this requirement he need only Manager Name, so Remove Duplicate Records will show only unique records.