Question

4
Replies
206
Views
AGRAA Member since 2010 4 posts
PEGA
Posted: 4 years ago
Last activity: 3 years 11 months ago
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
Share this page LinkedIn