Create Single Report by using Multiple Table-One-To-Many Relationship Table structure
We have a requirement to generate a single Report which will join multiple Tables to get the required data and later data will be exported to Excel or any kind of file format.
Pain Areas:
we do have technical challenge in joining multiple tables to create a single Report, because data inside each table is a bit complex and repetitive in nature.
For E.g: Table 1 is the Parent and Table 2,3,4,5 are child Tables and it has one-to many relationship in terms of data mapping.
We have a requirement to generate a single Report which will join multiple Tables to get the required data and later data will be exported to Excel or any kind of file format.
Pain Areas:
we do have technical challenge in joining multiple tables to create a single Report, because data inside each table is a bit complex and repetitive in nature.
For E.g: Table 1 is the Parent and Table 2,3,4,5 are child Tables and it has one-to many relationship in terms of data mapping.
Please let us know if there any alternate solutions/Approach to fulfill this requirement.
Pegasystems Inc.
IN
Find an old article but worth checking once.
https://docs-previous.pega.com/how-chain-together-multiple-joins-report-definition-rule