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.
6086 sites
121 fans
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
  • Andrew
    Wed, 8 Mar 2017, 7:36 PM
    Hi Edmund Evangelista "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?"

    Yes. Just copy a filter from the component folder, change a few variable names and update your lang/en details.
  • Picture of Mo Elhammamy
    Wed, 3 May 2017, 1:48 PM
    Hi, Is there an upgrade for moodle 3.2 or this will can work?
  • Picture of Nicola Ribatti
    Fri, 26 May 2017, 7:33 PM
    Hi to all. I have a question. I Have created a database activity in wich student insert their name, activities and hours of activity. How (with a sql query) can I get the amount of the hours for each student? Thank you very much
  • Picture of Miguel González Laredo
    Tue, 30 May 2017, 4:06 PM
    Hi Nicola, I'm writing you by inner messenger ( to help you.
  • Picture of Yegor Grishko
    Thu, 15 Jun 2017, 4:49 PM

    Any news on version for Moodle 3.3? Tried installing and it does not work, does anyone have a workaround maybe? Thank you!
  • Ben Haensel
    Thu, 15 Jun 2017, 11:56 PM
    Does anyone have any documentation on setting up the configurable reports plugin to a remote DB? My Moodle 3.1 is running MySQL and I'm attempting to connect to another DB in our hosted environment that is running SQL Server 2008.
  • Picture of Julie Gray
    Tue, 20 Jun 2017, 10:59 PM
    Hi there,
    Any news for moodle 3.2?
  • Picture of Michael Woods
    Wed, 21 Jun 2017, 7:25 AM
    Hi all, I've been using this plugin in Moodle version 3.2 for the past 6 months, and all good so far. In the version.php, it is release 3.1.1 and version 2016020103.
  • Picture of Yegor Grishko
    Wed, 21 Jun 2017, 12:19 PM
    Hello Michael, what version of php are you using?
  • Picture of deva m
    Wed, 21 Jun 2017, 1:03 PM
    Hi Juan Leyva,
    what about viewing report in hierarchy(Organisation) basis , whether this scenario is achievable or not ?
  • Picture of Michael Woods
    Wed, 21 Jun 2017, 2:00 PM
    Hi Yegor, we are using php 7 on Ubuntu 16 LTS.
  • Picture of Yegor Grishko
    Wed, 21 Jun 2017, 4:40 PM
    Im having issues installing it on 3.3, running php 7 and Ubuntu 16 lts. Surprised it is working for you in 3.2. I will have to try then.
  • Picture of Chris Khoo
    Sat, 1 Jul 2017, 8:17 PM
    I am using Moodle 3.3 (Build: 20170515).

    I am getting this error. Is it because my Moodle version is not supported?

    Validating block_configurable_reports ... Error
    [Error] Write access check [/opt/bitnami/apps/moodle/htdocs/blocks]
    Installation aborted due to validation failure
  • Picture of Brandon Jimenez
    Wed, 5 Jul 2017, 3:46 AM
    Hello Juan

    i keep have a strange error while using your plug (Moodle 2.9.9...):

    I'm trying to create a template using the documentation you have provided for your plug, but my editor (atto) keeps adding some additional tags so i can't complete the new template as i would like to. I realise this is not 100% your plugin's fault, but, in short, is there any workaround from the settings of your plug to allow using the template as defined in the tutorial?

  • Ben Haensel
    Wed, 19 Jul 2017, 10:57 PM
    Has anyone used a variable in the URL string of the report in a SQL query? It would be great to pass the userid in a url string from one report to link to another report where that userid is used as a variable in the query. If you have (or could conceive how to do this), please share!

    Also, is it possible when using the search text filter to have no results initially before applying a filter? Thanks for any feedback! -Ben
1 2 3 4 5 6 7 8 9 10 11
Please login to post comments