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.
6428 sites
216 fans

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
  • Aaron Cauchi
    Mon, 26 Feb 2018, 1:35 PM
    Cannot give rights to non-editing teacher or any other role rights to view block in any course. One has to be a manager to see the block. I need a non editing teacher capability to view reports. Am using Moodle version 3.1.2+ (Build: 20161027)
  • Picture of David Heuring
    Sun, 11 Mar 2018, 2:24 PM
    When I select "User filter search box" in an SQL report, I get the following error message. Moodle: 3.4+; Config Reports: 3.1.1 (2016020103); Fordson theme V1.7. Is this a bug?

    Stack trace:

    line 42 of /blocks/configurable_reports/components/filters/fsearchuserfield/form.php: Error thrown
    line 204 of /lib/formslib.php: call to fsearchuserfield_form->definition()
    line 149 of /blocks/configurable_reports/editplugin.php: call to moodleform->__construct()
  • Ricardo Caiado
    Sat, 17 Mar 2018, 10:51 PM

    Any update to Moodle 3.4?

  • Picture of Michael Milette
    Mon, 26 Mar 2018, 5:48 AM
    Hi Juan,

    Love this plugin and use it on MANY Moodle sites. However it hasn't officially been compatible with Moodle 3.2+ and PHP 7.x.

    The Moodle community is wondering if you are planning on releasing an update compatible with more recent releases of Moodle or if we should consider this plugin abandoned and focus on Ad-Hoc Database Queries which recently release a version compatible with Moodle 3.4. I understand that life can get in the way but we would really appreciate a quick note from you to learn you intentions... please. smile
  • Picture of Lebato MT
    Mon, 7 May 2018, 8:10 PM
    I have installed the plugin on moodle 3.4 and so far its working fine. But just to avoid compatibility issues later on, when will the 3.4 version of the plugin be released?
  • Picture of Stanley Lima
    Mon, 14 May 2018, 12:51 AM
    In the case of an abandoned plugin, the authors wouldn't likely be available apply a quick fix
  • Picture of Ericka Zuniga
    Wed, 6 Jun 2018, 2:04 AM
    Someone knows, Is it compatible with Moodle 3.5? or when will the 3.5 version of the plugin be released?
  • Picture of Madhu Avasarala
    Wed, 6 Jun 2018, 3:51 AM
    I use it on Moodle 3.5 and it appears to be working, however this is not an exhaustive test of all its capabilities.
  • Picture of Daniël de Villiers Hugo
    Mon, 16 Jul 2018, 9:07 PM
    It looks like there might be a issue on 3.3.2 . When you change the setting of one of the reports to be a global report (accesible from any course) , and you created it in the dashboard, it does not display on course level. However, if it was created in a course, then it is displayed in the dashboard also.
  • Picture of nicholas chandra
    Mon, 23 Jul 2018, 4:56 PM
    hello, i use it on Moodle 3.5 and i love it. However, whenever i generate record , the teacher role always generated as a student. Is it a bug or what?
  • myname
    Tue, 14 Aug 2018, 3:05 PM
    I am using Moodle 3.5 , is this plugin compatible with it?
    this plugin is really great
    Thank you
  • Picture of Michael Milette
    Fri, 7 Sep 2018, 9:53 AM
    Parts of it are compatible with Moodle 3.3, 3,4 and 3.5 however there are definitely issues. For example, you can create custom SQL reports but import existing reports does not work. Creating graphs doesn't work. Icons are broken and links to stylesheets are broken.

    I fixed some of these issues in my fork at which at least makes it useful in Moodle 3.3, 3.4 and 3.5. If anyone has fixes for remaining issues listed above, please share them so that we can all get this very useful plugin back into a working state.
  • Picture of Madhu Avasarala
    Wed, 12 Sep 2018, 10:39 AM
    Hi Michael, do you know if the sendemail feature is working in your fork? This is the feature where emails can be sent to selected users using the AS 'sendemail' for a column.
  • Picture of Daniel Antonio -
    Fri, 14 Sep 2018, 9:34 PM

    a suggestion for anyone who is having problems with plugin compatibility is to install moodle 3.1 on the same server and then install the plugin then you should point your sql syntax to the database of the new version of moodle. Sorry if it was not clear, I used the translator.
  • Picture of Michael Milette
    Wed, 10 Oct 2018, 9:57 AM
    Hi Madhu, I haven't tried the sendmail feature yet. The fork only includes fixes, not enhancements. I haven't touched the code for that at all. Give it a try and let us know. If it is an issue, hopefully someone will have a fix for it.
1 2 3 4 5 6 7 8 9 10 11 12 13 14
Please login to post comments