How to concatenate a column values coming from a sub-report and show it in the main report via a Report Definition?
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?