Your Moodle version

Blocks: 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.
Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9

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.


Screenshot #0


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 Madhu Avasarala
    Mon, Jul 4, 2016, 3:58 AM
    Good day Juan,

    Thanks for your excellent plugin. I am looking to see if I can modify the plug-in to be able to update a profile field for several users to some value. So for example I would use the report to generate a filtered list of users and then update a profile field (for example profile_field_feespaid) to yes for all of them. Would you be kind of enough to suggest pointers to do so as in where in the code to start with, etc? Thanks for your help.
  • Picture of Олег Танюкевич
    Fri, Jul 8, 2016, 4:44 PM
    Hello, tell me how to solve the problem.
    Choosing a report filter "Search custom fields" me "throws out" on empty page and nothing happens anymore.
  • Picture of OKonmah Henry
    Thu, Jul 14, 2016, 10:53 PM
    please, i need help, i have configured the block report on my moodle but is not bringing the report as i expect, especially the pictures and courses took by the student is not showing, please, can someone help me. thanks
  • Picture of JC IP
    Wed, Aug 17, 2016, 3:12 AM
    Hi Juan, there are plans to include the execution of stored procedures into the plugin?
  • Picture of Juan Leyva
    Mon, Aug 22, 2016, 5:48 PM
    Hi, not in the short-term, I don't have time to add new features, just maintenance
  • Picture of Mathew Gancarz
    Wed, Sep 7, 2016, 5:35 AM
    Is there any way to filter viewing of a report by course groups or only to specific users? The idea is to provide teachers in a group only access to view the students in their own group, with 2 or more groups in the course. It looks like using User field value many times could be a workaround, but it only lets me add one instance of that permission.
  • Picture of Rafa Gonzalez
    Thu, Sep 15, 2016, 6:05 PM
    Hello, I have moodle 2.9.2 with configurable_reports (2011040121)

    But I have the error:

    get_role_users() without specifying one single roleid needs to be called prefixing role assignments id ( as unique field, you can use $fields param for it.

    line 4114 of /lib/accesslib.php: call to debugging()
    line 45 of /blocks/configurable_reports/components/conditions/usersincurrentcourse/plugin.class.php: call to get_role_users()
    line 347 of /blocks/configurable_reports/report.class.php: call to plugin_usersincurrentcourse->execute()
    line 384 of /blocks/configurable_reports/report.class.php: call to report_base->elements_by_conditions()
    line 69 of /blocks/configurable_reports/viewreport.php: call to report_base->create_report()

    How i can solve it?

  • Picture of Alejandro Piñango
    Sun, Sep 18, 2016, 2:01 PM
    Hi, I have Moodle 3.1.1 and Configurable Reports get me this error:

    Detectado un error de codificación, debe ser corregido por un programador: Function get_all_mods() is removed. Use get_fast_modinfo() and get_module_types_names() instead. See phpdocs for details.

    How can I do?

    Best Regards
  • Picture of Sakshi Goel
    Mon, Sep 19, 2016, 4:23 PM
    Hello, I am using this plugin with Moodle 3.1+ and getting this error when printing reports :

    'object' class has been deprecated, please use stdClass instead.
    line 71 of /lib/setuplib.php: call to debugging()
    line 175 of /blocks/configurable_reports/locallib.php: call to object->__construct()
    line 183 of /blocks/configurable_reports/locallib.php: call to urldecode_recursive()
    line 183 of /blocks/configurable_reports/locallib.php: call to urldecode_recursive()
    line 221 of /blocks/configurable_reports/locallib.php: call to urldecode_recursive()
    line 93 of /blocks/configurable_reports/reports/sql/report.class.php: call to cr_unserialize()
    line 71 of /blocks/configurable_reports/viewreport.php: call to report_sql->create_report()

    Please let me know is it work with Moodle 3.1
  • Picture of Peter Bowen
    Fri, Sep 30, 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?

  • Picture of Greg Morris
    Wed, Oct 12, 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.


  • Picture of Greg Morris
    Fri, Oct 14, 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, Oct 24, 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, Oct 24, 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, Oct 25, 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.

1 2 3 4 5 6 7 8 9
Please login to post comments