Posted: 26 Feb 2019 9:05 EST Last activity: 25 Mar 2019 6:25 EDT
Quiz question related to Subreports
Following is one of the questions from the quiz of the topic "Creating reports that combine data from multiple classes."
You create a report that uses data from two classes. Which of the following reporting requirements requires the use of a subreport?
(A) Columns to display are: Operator Name, Last updated Case ID, Last updated Case Status, Update Date.
(B) Columns to display are: Operator Name, Operator Division, Count of Purchase Requests created.
(C) Columns to display are: Manager, Name, Count of operators that report to each manager.
(D) Columns to display are: Operator Name, Operator Division, Count of Purchase Requests created by the operator. Filter the results by unresolved status.
Answer : C
Explanation from Training website:
You use an aggregate function in a subreport to determine the count of divisions to which the operator belongs.
My questions : Why would this option require "count of divisions" and subquery. I was thinking the Option (A) is the answer because sub-report is used to find the operator id and latest update date from work table and the main report will use those two columns from subreport to identify the other columns needed for the report from work table.