Question
2
Replies
5549
Views
Posted: December 9, 2016
Last activity: April 17, 2017
Closed
Solved
How to concatenate a column values coming from a sub-report and show it in the main report via a Report Definition?
Hi All,
I have a Report Definition on Organization table joining multiple tables. I have a sub-report to run on some other set of tables. Now, for each record in main report, I might get multiple records on joining with sub-report because each Organization may have multiple Firms associated to it.
The requirement says that the multiple firm names should be shown as comma separated values in one column in the main report. How to achieve this?
Your requirements needs recursion in SQL (or a different aggregate function) which is currently not available in Report Definitions. Please raise an enhancement request (or follow up with your Pega account executive) and product management will consider your use case. If you have more use cases which require this, please shre them in your request.