Ali Qadir (AliQ8537)
Booz Allen Hamilton

Booz Allen Hamilton
AliQ8537 Member since 2019 2 posts
Booz Allen Hamilton
Posted: April 2, 2020
Last activity: April 2, 2020
Posted: 2 Apr 2020 16:03 EDT
Last activity: 2 Apr 2020 16:03 EDT

Building reports based on sum of 2 case types and properties associated to the 2 different case types

Hello All,

I currently have a requirement to build reports in (using pega version 8.3.) I was wondering if its possible to build a report that pulls the amount of total cases that are tied to a certain property that are used in two different case types as well as the total sum of both case type in one report. 


There are two different case types which I need to report on, is it possible to do this in one report? For more context an example would be to create a list/ summary report that lists total/sum of cases of case type x as well as type y.


The last requirement is to report the use of a specific property that is used in both case types and list total/all cases (case type x plus case type y), total pages of case type x, total cases of case type y, and total case type of case type x


For example a insurance policy holder (PolicyHolderName) is a property that is used in case type PNG-TrustyInsurance-Work-Quote, as well as PNG-TrustyInsurance-Work-Review I would need a report that lists: 



- Total cases 

-Total Quote cases

-Total Review cases

-Total Pages of case Quote

-Total Pages of case review


and so on an so forth based on all PolicyHolderName


Many thanks in advance on any input or guidance on how to implement this requirement (or if it is possible) So far i have been experimenting with creating a custom report definition however given the fact that two case types are involved I wanted to know if there is a more efficient way to implement these requirements. Once again thank you very much for the support (:


***Edited by Moderator Marissa to update Content Type from Discussion to Question***


Pega Platform 8.3 Enterprise Application Development Dev/Designer Studio Other Industry Senior System Architect
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.