Discussion1Replies110Views×Close popoverGiridhar Metikal (Giridhar_Metikal) Instellars Global Consulting Consultant Instellars Global Consulting SG View Profile Giridhar_Metikal Member since 2014 95 posts Instellars Global Consulting Posted: May 25, 2016Last activity: May 26, 2016Posted: 25 May 2016 12:55 EDTLast activity: 26 May 2016 12:10 EDT 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 agoPosted: 26 May 2016 12:10 EDT×Close popoverLee Pederson (pedel) PEGA Principal Instructor Pegasystems Inc. US View Profilepedel 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.