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:
14141 sites
4k downloads
435 fans
Current versions available: 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

Juan Leyva (Lead maintainer)
Sara Arjona Téllez: Developer
Please login to view contributors details and/or to contact them

Comments RSS

Comments

  • Lisa Nally
    Wed, 22 June 2016, 4:06 AM
    Juan,

    HI! I'm hoping you see this. Is there anyway to create a report where Moodle automatically exports it using the Configurable Reports block? For example, if I want a report ran every day at 2 AM, can I do that through this block? If not, do you have any idea what can do this? I'm using Moodle 1.9.

    Thanks!
  • Roula Karam
    Wed, 29 June 2016, 10:02 PM
    Dear Juan,
    We are trying to manipulate the Configurable Reports plugin on moodle 3.1, but we encountered a problem while visualizing the bar graph as if : missing Bar Type (height, width)

    Did you remember to call setType() for 'width'? Defaulting to PARAM_RAW cleaning.
    • line 1320 of /lib/formslib.php: call to debugging()
    • line 292 of /lib/formslib.php: call to moodleform->detectMissingSetType()
    • line 203 of /lib/formslib.php: call to moodleform->_process_submission()
    • line 149 of /blocks/configurable_reports/editplugin.php: call to moodleform->__construct()
    Did you remember to call setType() for 'height'? Defaulting to PARAM_RAW cleaning.
    • line 1320 of /lib/formslib.php: call to debugging()
    • line 292 of /lib/formslib.php: call to moodleform->detectMissingSetType()
    • line 203 of /lib/formslib.php: call to moodleform->_process_submission()
    • line 149 of /blocks/configurable_reports/editplugin.php: call to moodleform->__construct()
    Coding error detected, it must be fixed by a programmer: Function get_all_mods() is removed. Use get_fast_modinfo() and get_module_types_names() instead. See phpdocs for details
    Debug info:
    Error code: codingerror
    Stack trace:
    • line 1267 of /lib/deprecatedlib.php: coding_exception thrown
    • line 46 of /blocks/configurable_reports/components/columns/usermodactions/form.php: call to get_all_mods()
    • line 192 of /lib/formslib.php: call to usermodactions_form->definition()
    • line 149 of /blocks/configurable_reports/editplugin.php: call to moodleform->__construct()

    Thank you so much for the support of everybody in this forum.
  • Juan Leyva
    Thu, 30 June 2016, 3:50 PM
    Hi,
    please, can you open a bug in the Moodle Tracker for the component? https://tracker.moodle.org/secure/Dashboard.jspa project contrib, COMPONENT block configurable reports
  • Madhu Avasarala
    Mon, 4 July 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.
  • Олег Танюкевич
    Fri, 8 July 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.
  • OKonmah Henry
    Thu, 14 July 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
  • JC IP
    Wed, 17 Aug 2016, 3:12 AM
    Hi Juan, there are plans to include the execution of stored procedures into the plugin?
  • Juan Leyva
    Mon, 22 Aug 2016, 5:48 PM
    Hi, not in the short-term, I don't have time to add new features, just maintenance
  • Mathew Gancarz
    Wed, 7 Sept 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.
  • Rafa Gonzalez
    Thu, 15 Sept 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 (ra.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?

    Thanks.
  • Alejandro Piñango
    Sun, 18 Sept 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
  • Sakshi Goel
    Mon, 19 Sept 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
  • Peter Bowen
    Fri, 30 Sept 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
  • 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
  • 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
Please login to post comments