Posted: 4 Dec 2017 10:26 EST Last activity: 8 Dec 2017 9:48 EST
Subreports in Report Design Quiz SSA 7.2
I have confused with the following quiz in Report Design SSA 7.2
You are creating a report that uses data from two classes. Which of the following reporting requirements requires the use of a subreport?
Columns to display are: Operator Name, Last updated Case ID, Last updated Case Status, Update Date.
Columns to display are: Operator Name, Operator Division, Count of Purchase Requests created by the operator. Filter the results by unresolved status.
Columns to display are: Operator Name, Operator Division, Count of Purchase Requests created.
Columns to display are: Manager, Name, Count of operators that report to each manager.
You use an aggregate function in a subreport to determine the count of divisions to which the operator belongs.
Can please somebody explain me why subreport is needed for this quite simple list and how count of divisions to which operator belongs, which is mentioned in the explanation of answer, is connected with count of operators that report to manager?
BTW, I have not found any mentioning in the course of what class contains details of reporting to managers, so this information could be very usefull as well
If you take a look at the section "How to combine data from different classes using a subreport" that should give you the information you are looking for. On that page there is a explanation of "Using aggregation to create a subreport" where it is specifically called out that subreports can be used to display aggregate calculations on specific rows.
Slightly below that there is an explanation that for example a subreport can be created that shows the managers who have direct reports, how many they have and filter conditions can be used to limit the data to managers who are part of a division.
Thanks for answering. It explains subreport usage, but I have huge doubts that sample at all has correct logic
I am quite sure that property "Reports To" contains id of manager to whom operator reports. So when we need list of managers and count of direct reports, we should use in subreport something like following:
Report To - it is manager (and it should be not null)
count (Operator ID) - it is count of operators that reports to manager directly
Thus, we can not use here filter on division, because here it can filter only operators under count, but not managers, correct?
Still we can join this subreport (SR) to main using condition SR.routeTo = .OperatorID and use filter on division here
I agree that something still just does not seem right about the logic on this but I am having some challenges figuring out what I am missing here. Let me look into it some more to see if I cannot provide some additional details. Nothing like a challenge. ;-)