Configurable Reports

Blocks ::: block_configurable_reports

Maintained by

Juan Leyva,

Sara Arjona Téllez

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.

Latest release: 3 years

14141 sites

4k downloads

435 fans

Current versions available: 5

Download

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.

Links

Support forum

Useful links

Screenshots

Contributors

Juan Leyva (Lead maintainer)

View other contributions

Sara Arjona Téllez: Developer

View other contributions

Please login to view contributors details and/or to contact them

Awards

Privacy friendly

Early bird 3.7

Early bird 3.10

Comments

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
Hi,

Any update to Moodle 3.4?

Ricardo
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.
Millicent 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?
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
Ericka Zuniga
Wed, 6 June 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?
Madhu Avasarala
Wed, 6 June 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.
Daniël de Villiers Hugo
Mon, 16 July 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.
nicholas chandra
Mon, 23 July 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?
m question
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
Michael Milette
Fri, 7 Sept 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 https://github.com/michael-milette/moodle-block_configurablereports/tree/MOODLE_33_STABLE 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.
Madhu Avasarala
Wed, 12 Sept 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.
Daniel Antonio da Silva
Fri, 14 Sept 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.
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.
siham admin
Mon, 22 Oct 2018, 7:08 PM
Hi,

This Plugin is really great and helpful , Thank you so much.
But i really need to export my reports in PDF in Moodle 3.5
HELP Please.

Regards,