Discussion1Replies106Views Giridhar_Metikal Member since 2014 95 posts Instellars Global Consulting Posted: 4 years agoLast activity: 4 years 4 months ago Closed Query on SSA (7.1) Quiz - Configuring Reports Which of the following reports will MOST LIKELY require the use of a sub report? (Choose One)1. Columns: Operator Name, Operator Division, Count of Purchase Requests created; Grouped first by Division, then by Operator2. Columns: Operator Name, Count of Purchase Requests created; 1 row of every operator3. Columns: Operator Name, Operator Division, Count of Purchase Requests created; 1 row of every operator (Correct Answer)4. Columns: Operator Name, Operator Division, 1 row of every operator In the above quiz question, how to implement options 1 and 3? Pega Academy ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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 Discussion, please write a new Discussion. Posted: 4 years agopedel PEGA replied to Giridhar_MetikalQuestion 1 is an INNER/LEFT join between Operator and PurchaseRequest pxCreateOperator. In that report, the COUNT(pyID) of Purchase Requests per Operator can displayed as opposed to listing every PurchaseRequest. Question 3 is asking that every Operator be displayed regardless the Operator having created a PurchaseRequest. The solution is to use Question 1's report as a subreport to a report that lists every Operator. The subreport would be configured as a RIGHT join.