Blocks: Configurable Reports

block_configurable_reports
Maintained by Picture of Juan Leyva Juan Leyva
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.
5829 sites
5k downloads
80 fans
Moodle 2.0, 2.1, 2.2, 2.3, 2.4, 2.5

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.

Screenshots

Screenshot #0

Contributors

Picture of Juan Leyva
Juan Leyva (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Picture of Peter Bowen
    Fri, 30 Sep 2016, 5:31 AM
    Hi Juan,
    We recently upgraded from 2.3.7 to 2.3.9, and noticed the reports have slowed incredibly. I back revved to code 2.3.7, and speed has returned.
    For example, one report under 2.3.7 takes 8 seconds to run, but takes 1:11 under 2.3.9.
    A second report takes 3 seconds under 2.3.7, but about 12 seconds under 2.3.9.

    This is consistent across the 5 sites I run.

    Has any one else reported, or are experiencing these issues?

    Cheers
    Peter
  • Picture of Greg Morris
    Wed, 12 Oct 2016, 4:25 PM
    Hey there,

    Thought I'd give this a try today. Getting a 500 error on trying to install the plugin.

    Moodle 3.1. Trying your latest version.

    Cheers

    G
  • Picture of Greg Morris
    Fri, 14 Oct 2016, 12:33 AM
    I got it working by downloading the source from Github and manually copying to the Blocks directory. Thanks smile
  • Picture of Edmund Evangelista
    Mon, 24 Oct 2016, 11:48 AM
    I intend to share the configurable reports I have made to teachers. I added permission for them to view the configurable reports block yet they cannot still see the report. Any suggestions?
  • Picture of Brandon Jimenez
    Mon, 24 Oct 2016, 10:59 PM
    Hi, just a quick question that i couldn't find anywhere answered: can i change the name of the generated xls file? Right now the plug generates a 'report-xxxx.xls' the number i think being the timestamp. I, however, would like to configure it to be 'my_most_awesome_report.xls'. Can it be done?
  • Picture of Sri Hari Varma Kalidindi
    Tue, 25 Oct 2016, 5:10 PM
    Hi Juna,

    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
  • Picture of Erika Khoury
    Thu, 27 Oct 2016, 2:23 PM
    Hi Juan,

    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
  • Picture of Martin Greenaway
    Thu, 27 Oct 2016, 9:31 PM
    @Edmund - Which page are they looking at? Do they need to add the configurable reports block to a page?
  • Picture of Edmund Evangelista
    Tue, 1 Nov 2016, 6:28 PM
    How to change the Semester (Hebrew) dropdown list into English?
  • Picture of Edmund Evangelista
    Thu, 3 Nov 2016, 1:43 PM
    @Martin, I will be adding a "Reports" link with submenu in top menu of Moodle, all the reports I have created will appear on that link.
  • Picture of Edmund Evangelista
    Thu, 3 Nov 2016, 1:46 PM
    Is there a way not to auto load the report? All I want is our teachers to select first any filter I have provided before the report will load. Some reports are huge thus I need the filter first to be selected before it loads any report.
  • Picture of Edmund Evangelista
    Thu, 3 Nov 2016, 1:59 PM
    Hi Juan thanks by the way for this awesome report tool. Is there a way to add custom filters like semester (in English), academic year, department and so on? What are steps in order to push this filter to appear in the filters of configurable reports? I tried also duplicating a certain filter with another name, but I always get an error.
  • Picture of Edmund Evangelista
    Thu, 3 Nov 2016, 2:39 PM
    Hi Juan, is there a way to modify the text of Search Text filter instead of the default text "Filter" to change it to something like "Academic Year" or any text I would want?
  • Picture of Khaled AYARI
    Tue, 22 Nov 2016, 11:34 PM
    Hi everybody, i have moodle 3.0.4+ version and installed configurable reports ont it (v 3.1.0). The problem i face actually is when i type this request is that only the students are reported and not the other roles like teacher, manager, ... even i've verified in moodle that everyone exist :

    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
  • Ricardo Caiado
    Wed, 7 Dec 2016, 8:24 PM
    Any upgrade to Moodle 3.2?
1 2 3 4 5 6 7 8 9
Please login to post comments