VipinK17 Member since 2013 14 posts
Accenture Services Pvt Ltd.
Posted: 1 year ago
Last activity: 1 year 1 month ago

Does MSOGenerateExcelFile support nested pagelist to display grouped data

I'm able to use the MSOGenerateExcelFile to generate excel with pagelist data. i.e. i can load a table in excel using this pagelist property.

The requirement is to be able to display multiple tables or multiple list with group header.

For e.g.

First display claim details for Patient 1 with heading of patient name

Then second patient claims with Patient name in header and so on.. we do not want to hardcode patient #.

Patient Name: ABC (.patient(1).name)

Claim No (.patient(1).claim().ClaimNumber) , Amount (.patient(1).claim().Amount)

C1, 453.00

C2, 451.00

Patient Name: DEF (.patient(2).name)

Claim No (.patient(2).claim().ClaimNumber) , Amount (.patient(2).claim().Amount)

C1, 73.00

C2, 51.00

C3, 10.00

If supported, how do we format the template to achieve this? Really thanks in advance!

***Edited by Moderator Marissa to update platform capability tags****

Pega Platform Low-Code App Development Data Integration Java and Activities
Moderation Team has archived post
Share this page LinkedIn