Hello,

Our client needs a report a report which involves data from a top level case and  two levels of sub cases, ProjectCase

   FASub

       WASub.

A Project case can have multiple FA sub cases and each FA sub case can have multiple WA sub cases.

The report contains a flat list of data at the ProjectCase level, and the aggregate data elements from both sub levels. One of the challenges we are facing with OOTB report definition is pagination. Client wants pagination and when you have aggregate data in Rep Def, OOTB pagination is not allowed.The challenge with Custom UI is the header labels for the FA Cases.

How to approach this kind of requirement?

Thanks,

Pradeep