Discussion
2
Replies
109
Views
Posted: June 10, 2016
Last activity: June 10, 2016
Closed
Reporting Doubt
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)
a) List Report in the Worklist Assignment Class.
b) Summary Report in the Worklist Assignment Class.
c) List Report in the Operator Class with a subreport.
d) Summary Report in the Operator Class
Correct answer is c.
Can someone please elaborate.
Hello Nisarg
The above requirement can only be fulfilled if we use subreport, If we try to use summary report we can either display "Operator Firstname, Count of assignments" or "Operator lastname, Count of assignments", i.e. the grouping will be based on all of the remaining columns where aggregate function is not used, however if you have requirement like above that you will operator FName, LName and count of assignments (group by operator id), you will need to use subreports. You can try to create the reports and see what the difference is,
This is similar if you use an SQL query using GROUP By clause and do not use an aggregate function you will get an error.
Regards,
Sandeep