Index: lib.php =================================================================== RCS file: /cvsroot/moodle/moodle/grade/report/grader/lib.php,v retrieving revision 1.98.2.29 diff -u -F ^f -r1.98.2.29 lib.php --- lib.php 12 Feb 2008 08:19:50 -0000 1.98.2.29 +++ lib.php 13 Feb 2008 03:12:34 -0000 @@ -346,9 +346,13 @@ function get_numusers($groups=true) { global $CFG; + if ($this->sortitemid == 'lastname') { + $sortitemid = 'u.'. $this->sortitemid; + } + $countsql = "SELECT COUNT(DISTINCT u.id) FROM {$CFG->prefix}grade_grades g RIGHT OUTER JOIN - {$CFG->prefix}user u ON (u.id = g.userid AND g.itemid = $this->sortitemid) + {$CFG->prefix}user u ON (u.id = g.userid AND g.itemid = $sortitemid) LEFT JOIN {$CFG->prefix}role_assignments ra ON u.id = ra.userid "; if ($groups) { $countsql .= $this->groupsql;