Select Moodle version:

Blocks: Configurable Reports

block_configurable_reports
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.
Maintained by: Picture of Juan Leyva Juan Leyva
for Moodle
2.2, 2.3, 2.4, 2.5, 2.6

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

Contributors

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

Comments RSS

Show comments
  • Picture of Juan Leyva
    Fri, Jan 24, 2014, 5:07 PM
    Hi Michael,

    i thought the Warning was solved in the previous release.

    I just added the format_string, you can download the last version from github

    I'll try to release a new version these days
  • Picture of Michael Milette
    Mon, Jan 27, 2014, 3:36 AM
    Thanks Juan!

    Tested out the version on GitHub and it all looks great. Thank you for your prompt response and the fixed version.

    Best regards,

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

    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: https://moodle.org/mod/forum/discuss.php?d=223419

    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?

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

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

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

    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 Leïla Hiret
    Fri, Apr 18, 2014, 1:44 AM
    Impossible to make the plugin work. I installed it without problem.
    I Can use the first screen and create a report name with its description but when I validate this first screen, I am not redirected to the first Tab named "Columns, as showns in your tutorial. I have the following bug that says: "the link seems to be broken.
    Moodle version : 2.6
    Role : administrateur
    Installation: automatic procedure
    Thanks for your help.
1 2 3 4
Please login to post comments