It should work, the sql query works fine? Can you copy and paste here the sql query?
This is the SQL report code which I am using:
SELECT cc.name AS 'Category', c.fullname AS 'Course', u.firstname AS 'Name', u.lastname AS 'Surname',
ROUND(gg.finalgrade,2) AS Score,ROUND(gg.rawgrademax,2) AS Max,
IF (ROUND(gg.finalgrade / gg.rawgrademax * 100 ,2) > 59,'Yes' , 'No') AS Pass
FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_grade_grades AS gg ON gg.userid = u.id
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid
JOIN prefix_course_categories AS cc ON cc.id = c.category
%%FILTER_COURSES:c.id%%
%%FILTER_CATEGORIES:c.category%%
WHERE gi.courseid = c.id AND gi.itemname != 'Attendance'
ORDER BY 'Name' ASC
I also get these warning messages appearing:
Warning: array_shift() expects parameter 1 to be array, object given in /home/moodlelm/public_html/moodletest/blocks/configurable_reports/components/plot/pie/form.php on line 45
Warning: Invalid argument supplied for foreach() in /home/moodlelm/public_html/moodletest/blocks/configurable_reports/components/plot/pie/form.php on line 47
Please, download the last version of the plugin: https://github.com/jleyva/moodle-block_configurablereports/zipball/MOODLE_21_STABLE where this is fixed
Hi Juan, It works now but I still can't generate line graphs though. Pie graphs are working now.
This is the debugging error I get when I try to generate the line graphs.
Warning: array_shift() expects parameter 1 to be array, object given in /home/moodlelm/public_html/moodletest/blocks/configurable_reports/components/plot/line/form.php on line 45
Warning: Invalid argument supplied for foreach() in /home/moodlelm/public_html/moodletest/blocks/configurable_reports/components/plot/line/form.php on line 47
Download again the plugin following the link of my previous post, I fixed it also a few days ago
Very thanks for reporting the bug
