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.
Posted: 5 years ago
Updated: 5 years ago
Posted: 10 Jun 2016 16:49 EDT Updated: 10 Jun 2016 21:52 EDT
Lee Pederson (pedel)
Global Tech Enablement, Principal Instructor - LSA