Discussion
Query on LSA (7.1) Quiz - PRPC Reporting Strategy - Sub Reports
A report must have the following columns: Operator Last Name, Operator First Name, Count of Open Assignments. What report is best suited for this requirement? (Choose One)
1. List Report in the Worklist Assignment Class.
2. Summary Report in the Operator Class.
3. List Report in the Operator Class with a subreport. (Correct Answer)
4. Summary Report in the Worklist Assignment Class.
In the above question, in the option 3, the subreport is of Worklist Assignment Class where we get the list of Open Assignments. The main report compares for the operator ID and gets all the records of open assignments for that operator. We will use a count of these records in the main report. Please let me know if this will work out or correct me if I am wrong? Thanks in advance.
Yes, I agree. But could you also explain, why Option-3 is Best Suited.
Is it because in Option-2 we will be going to use OUTER-join and that will be showing a guardrail warning? Please correct me if my understand is incorrect.
The question does not clarify that it is wanting to list ALL operators regardless their having an Assignment (all Assignments are "open" BTW).
With your approach you would never show operators with a count of zero.
Answer (2) is also correct
What you can do for (2) is RIGHT JOIN the Operator to Assign-Worklist using "All rows in this class" -- this class meaning Data-Admin-Operator-ID, the RIGHT-JOINed class being Assign-Worklist.
You can then say COUNT(ASSIGN.pxRefObjectKey).
For Answer (3) you would write a Assign-Worklist subreport that simply counts pxRefObjectKey per pxAssignedOperatorID
You would then RIGHT JOIN that subreport to a basic list of Data-Admin-Operator-ID.