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

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.




Picture of Juan Leyva
Juan Leyva (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • C'est moi :-)
    Thu, Jan 30, 2014, 11:12 PM

    Since version 2.3 released in december 2013 (and even with 2.3.2), i've got a big problem : on SQL query tab, no area shows anymore to enter/modify SQL query sad
    I've just got numbers (corresponding to each line i think) showing.
    Tested with default theme in Moodle 2.4.8.

    It seems it's what Chris Chapman talked about on 17 december 2013.

    Hope you'll can make something to repair that.
  • Picture of Juan Leyva
    Thu, Jan 30, 2014, 11:24 PM
    Go to Administration Plugins Blocks Configurable reports, there should be an option called Highlight SQL syntax, disable that option
    New versions come with this option disabled
  • C'est moi :-)
    Thu, Jan 30, 2014, 11:40 PM
    Juan : thanks for this quick and good solution !
  • Just wondering . . .
    Thu, Feb 20, 2014, 12:12 PM
    Can this produce a report of all users NOT in a course? ie to delete spam accounts?
  • Just wondering . . .
    Fri, Feb 21, 2014, 4:04 AM
    Just a little point of interest:
    Put this plugin into our Moodle last night.
    Got errors this morning. "Coding error detected, it must be fixed by a programmer: Context does not belong to any course"

    A Google search of this leads us to ONE thread:

    If you have configurable reports on the front page it kills Moodle. Non-expert comment here: something to do with context? at home page level, it may not be doing what it needs to do?

  • Picture of Juan Leyva
    Fri, Feb 21, 2014, 5:22 PM
    Hi Derek,

    can you go to Administration / Development / Debugging and then "Debug messages DEVELOPER level" and also check the option "Display debug messages"

    And check again, please, copy and paste the full error message this will help me to trace and fix the error
  • poseypic
    Wed, Mar 5, 2014, 12:52 AM

    Keep getting this error recently when installing on a 2.5 site.
    The site used to be 1.9. I'm upgrading to 2.5 via 2.2...

    Unknown DDL library error

    More information about this error

    Debug info: table probably already renamed
    Stack trace:
    line 544 of /lib/ddl/database_manager.php: ddl_exception thrown
    line 41 of /blocks/configurable_reports/db/upgrade.php: call to database_manager->rename_table()
    line 724 of /lib/upgradelib.php: call to xmldb_block_configurable_reports_upgrade()
    line 273 of /lib/upgradelib.php: call to upgrade_plugins_blocks()
    line 1437 of /lib/upgradelib.php: call to upgrade_plugins()
    line 269 of /admin/index.php: call to upgrade_noncore()
  • poseypic
    Wed, Mar 5, 2014, 12:54 AM
    Sorry - Installing on a 2.2 site. Not even got as far as 2.5 yet...
  • poseypic
    Wed, Mar 5, 2014, 1:18 AM
    table already renamed issue:
    Ended up taking out the first if statement in upgrade.php as it had already renamed. Then also changed the version number in the upgrade save point at the end of the file as it thought I was downgrading to the same version somehow mixed
  • Picture of Victor-Manuel Hernandez
    Tue, Mar 18, 2014, 10:35 PM

    We are testing the plugin on a 2.6 installation.
    Once the plugin is installed, the system shows this error:

    La tabla "block_configurable_reports"no existe

    Debug info:
    Error code: ddltablenotexist

    Stack trace: •line 585 of /lib/dml/moodle_database.php: dml_exception thrown
    •line 1207 of /lib/dml/moodle_database.php: call to moodle_database->where_clause()
    •line 127 of /blocks/configurable_reports/block_configurable_reports.php: call to moodle_database->get_records()
    •line 775 of /blocks/moodleblock.class.php: call to block_configurable_reports->get_content()
    •line 238 of /blocks/moodleblock.class.php: call to block_list->formatted_contents()
    •line 956 of /lib/blocklib.php: call to block_base->get_content_for_output()
    •line 1008 of /lib/blocklib.php: call to block_manager->create_block_contents()
    •line 353 of /lib/blocklib.php: call to block_manager->ensure_content_created()
    •line 8 of /theme/azucarera/layout/frontpage.php: call to block_manager->region_has_content()
    •line 870 of /lib/outputrenderers.php: call to include()
    •line 800 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()
    •line 101 of /index.php: call to core_renderer->header()

    Any clue about this error?
  • Picture of Antonio Muñoz
    Mon, Mar 24, 2014, 7:35 PM

    I have a report with a column named "Dedication time". This column show the dedication time for every students.
    The problem is that the time is always zero. It seems that the report is not update well this field.

    Can anyone help me ?
  • Picture of Adam Orgill
    Tue, Mar 25, 2014, 11:10 PM
    Hi Juan,

    How can I add more than 1 user id in the permissions of a report, as is i can only add 1 and i have 4 users that need to see this report
  • Picture of Adam Orgill
    Wed, Apr 30, 2014, 1:01 AM
    Hi Juan, thanks for the help on the permissions, now i need to help to make the report show more than 5,000 rows....i need it to show about 100,000....any way to do that?
  • Picture of Adam Orgill
    Sat, May 10, 2014, 3:59 AM
    I have about created about 10 reports with the plugin and they are set to the front page (course 1). I have set permissions on each of the reports and used the user field option and i used the users username to give them their permissions to a report.

    now when some one logs into the moddle site it is very slow to show the front page, usually about 2 minutes....what can be done about this?
  • Picture of David Wylie
    Mon, Jun 30, 2014, 1:34 PM
    Hi Juan,
    Might you be able to tell me where user-created reports are stored within the Moodle folder on any given server?
1 2 3 4
Please login to post comments