Moodle plugins directory: Configurable Reports | Moodle.org
Configurable Reports
This block is a Moodle custom reports builder.
You can create custom reports without SQL knowledge. It's a tool suitable for admins or teachers.
What type of reports can I create?
- Courses reports, with information regarding courses.
- Categories reports, with information regarding categories. A courses report can be embedded in this type of report.
- Users reports, with information regarding users and their activity in a course.
- Timeline reports, this is a special type of report that displays a timeline. A course or user report can be embedded in this timeline showing data depending on the start and end time of the current row.
- Custom SQL Reports, custom SQL queries. This block can use the same SQL queries that Tim Hunt's Custom SQL queries plugin.
Note for developers: You can create your own type of reports.
Who can view the reports?
When you create a report you can select which users can view it.
Links to reports are displayed in a block in the course or site frontpage.
Advanced features
Filters, pagination, logic conditions and permissions, plots, templates support, export to xls .
Request for new report types and plugins are welcome, please use the link "Bugs and issues" at the right.
The "Print report" button (below the report) is not worink on IE and Chrome, when we click on it, the page flashes but nothing else happens However it is working on Firefox. I am using the latest moodle version (3.1.1) and the configuable reports plugin. Can you please help me out to reslove the issue with IE and Chrome.
Thanks,
Varma
I installed the plugin on 2.9 and the plugin works fine, but after I installed the plugin this option from moodle does not work anymore: Upload Courses admin/tool/uploadcourse/index.php I use Upload courses for bulk creation of courses based on another course as a template. The problem that the plugin cause is that the course is created but it does not import all the content from the other template course. I have been doing this process for a while. I create hundreds of similar courses. So this option is really important for us.
I tested it by removing the configurable reports plugin and the issue was gone.
I really like the plugin and I have an important report already running and being use for many.
I will appreciate any help,
Erika
The request:
SELECT
user2.firstname AS Prenom,
user2.lastname AS Nom,
user2.email AS Email,
course.fullname AS Cours
,(SELECT shortname FROM prefix_role WHERE id=en.roleid) AS ROLE
,(SELECT name FROM prefix_role WHERE id=en.roleid) AS RoleName
FROM prefix_course AS course
JOIN prefix_enrol AS en ON en.courseid = course.id
JOIN prefix_user_enrolments AS ue ON ue.enrolid = en.id
JOIN prefix_user AS user2 ON ue.userid = user2.id
the result is :
1 student 2 Conformité
2 2 Conformité
3 student 2 Conformité
4 student 2 Conformité
5 student 3 Déblocage
6 3 Déblocage
7 student 3 Déblocage
8 student 4 Fermeture des caisses
9 4 Fermeture des caisses
10 student 4 Fermeture des caisses
11 student 5 test
@import url("wwwroot/blocks/configurable_reports/js/codemirror/lib/codemirror.css");
@import url("wwwroot/blocks/configurable_reports/js/codemirror/addon/display/fullscreen.css");