Discussion 1 Replies 115 Views × Close popover Giridhar Metikal (Giridhar_Metikal) Instellars Global Consulting Consultant Instellars Global Consulting SG View Profile Send Message Giridhar_Metikal Member since 2014 95 posts Instellars Global Consulting Posted: May 25, 2016 Last activity: May 26, 2016 Posted: 25 May 2016 12:55 EDT Last 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 Operator 2. Columns: Operator Name, Count of Purchase Requests created; 1 row of every operator 3. 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 popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover 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 ago Posted: 26 May 2016 12:10 EDT × Close popover Lee Pederson (pedel) PEGA Global Tech Enablement, Principal Instructor - LSA Pegasystems Inc. US View Profile Send Message pedel PEGA replied to Giridhar_Metikal Question 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.