Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Naveen Mekala (NaveenReddyMekala)
Tech Mahindra
Naveen Mekala
Tech Mahindra
CA
NaveenReddyMekala Member since 2015 43 posts
Tech Mahindra
Posted: Jan 6, 2016
Last activity: Jan 7, 2016
Posted: 6 Jan 2016 1:41 EST
Last activity: 7 Jan 2016 5:56 EST
Closed
Solved

How to display multiple rows as a single column in listview?

Hi Team,

We are using PRPC 6.1 SP2. We have a table which saves multiple parties for a single pyID and we have a requirement to display all the rows of a single pyID be displayed in a single column.

For eg. Parties table contains 3 parties of Inquirer, Credit party and Debit Party with a party type column to differentiate the type of party.

Now we need to display columns in a listview as pyID, Inquierer Name, Inquirere ID, Credit party Name, Credit party ID, debit Party Name, debit party ID.

Is it possible to display as a single row in listview for multiple rows in parties table?

To see attachments, please log in.
Reporting

Posted: 8 years ago
Posted: 7 Jan 2016 5:56 EST
Srikanth Challapilla (Srikanth)
PEGA
Senior Manager, Security Engineering
Pegasystems
IN

We call this type of tables pivot tables. It is possible to do this in RD. configure the report to have pyID, Inquierer Name, Inquirere ID as group by columns and other columns as group by but display across columns set to true. You need atleast one aggregate column.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice