Question

4
Replies
208
Views
Ashish Agrawal (AGRAA)
PEGA
Technical Lead
PEGA
IN
AGRAA Member since 2010 4 posts
PEGA
Posted: August 14, 2016
Last activity: September 21, 2016
Posted: 14 Aug 2016 19:38 EDT
Last activity: 21 Sep 2016 10:52 EDT
Closed

Custom complex report

Hi All,

I have a requirement to create a report for following scenario:

Work objects belongs to multiple products say ProductA, ProductB, ProductC etc

Now Any WO may belong to one or multiple products.

I need to create a product that displays as follows:

ProductA - 10

ProductB-15

ProductC-5

Multiple-25

So here 10 WOs belong to only ProductA, 15 WOs belong to only productB ... and 25 WOs belong to multiple products... Now on drilldown on multiple, it will show as follows:

ProductA/ProductB-5

ProductB/ProdutC-5

ProductA/ProductC-15

i.e. 5 WOs belong to ProductA and Product B, similarly 15 WOs belongs to product A and ProductC...

 

Please suggest whats is the best way to acheive such report... (i mean we definitely need report, subreport, SQL function, but how to define, whats the logic...)

***Updated by moderator: Lochan | Closing the thread to future replies***

Low-Code App Development Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.