Discussion
1
Replies
115
Views
Instellars Global Consulting
Posted: May 25, 2016
Last activity: May 26, 2016
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?
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.