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

 Adarsha M (Adarsha_Mohan)
Wipro
Senior Consultant
Wipro
IN
Adarsha_Mohan Member since 2013 9 posts
Wipro
Posted: Dec 4, 2019
Last activity: Dec 4, 2019
Posted: 4 Dec 2019 0:16 EST
Last activity: 4 Dec 2019 3:31 EST
Closed

Display single row Data of Data base as multiple rows in report output

Hi,

i have a requirement to fetch the data from table and if one column is having multiple values, i need to display in output 2 different lines and i'm using report definition for fetching the data from tables.

attached screenshot of the requirement.

please advice.

thanks in advance

To see attachments, please log in.
Reporting
Data Integration

Posted: 4 years ago
Posted: 4 Dec 2019 3:31 EST
Basil (Vasilii) Pozdeev (vaspoz)
BPM Company
Senior System Architect
BPM Company
NL

The best approach would be to create a view in your database which will handle this requirement. 

Then you create a class which will be mapped to that view, and make a report on it.

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