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:
13590 sites
4k downloads
437 fans
Current versions available: 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 #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

  • Adam Orgill
    Sat, 10 May 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?
  • David Wylie
    Mon, 30 June 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?
    Thanks!
  • Jim Kesting
    Thu, 14 Aug 2014, 8:03 PM
    Hi. I am stuck. The report returns over 5000 regardless of filters, the filters are not working, and so this plugin has not been any help (yet). I was in 2.2, and now upgraded to 2.6 (dev) to see how it works... No luck.

    I have turned on debugging reports... nothing. My google searches almost show nobody is having any problems (except me). If the filter for date could work, then I can find a use. But because it returns 5000+ regardless of a date or user filter, I can not get anything out. The same happens in the Reporting Block for reports when I tested than in another Dev environment. Any help is appreciated.
  • Jim Kesting
    Fri, 15 Aug 2014, 4:37 AM
    Further to above, the database was created with Moodle 1.9, then upgraded to 2.2 last year. Is there likely to be a problem because of this?
  • Marcelo Schmitt
    Tue, 19 Aug 2014, 7:45 PM
    I use configurable report with moodle 2.7 and essential theme. It is a wonderful tool, but since my last theme update, when I enable javascript ordering, I get duplicate headers. What could be the problem?
  • Marcelo Schmitt
    Tue, 19 Aug 2014, 7:45 PM
    I use configurable report with moodle 2.7 and essential theme. It is a wonderful tool, but since my last theme update, when I enable javascript ordering, I get duplicate headers. What could be the problem?
  • Noritaka Yoshida
    Tue, 19 Aug 2014, 8:16 PM
    Hi,
    I get duplicate last column header too.
    I use configurable report with moodle 2.5.
    It's same on IE and Chrome and FireFox.
    Please tell me how to solve someone.
  • Trish Pini
    Wed, 20 Aug 2014, 4:49 AM
    Jim if you are using the sql report the filters do not work unless you also add a filter to the sql code. I am no expert however I was having the same problem and found if I pasted the following in the sql

    where 1=1
    %%FILTER_SEARCHTEXT:e.name:~%%

    Then I added the search free text filter using the tab and then it worked
  • Trish Pini
    Wed, 20 Aug 2014, 4:53 AM
    Should have added that you need to replace e.name with whatever field you wish to do the search on.
  • Sarah Smith
    Thu, 21 Aug 2014, 4:38 AM
    I have been attempting to update my site from 2.6 to 2.7. I had done this last month, but we ran into another issue (realized my template was 2.7 compatible yet), so I reverted back to 2.6.

    Well, now my template has been updated, so I wanted to try the 2.7 update again. I did my plugins check and then went on to upgrade the database. However, I get an error:
    Table "quiz_question_instances" already exists

    More information about this error
    Debug info: can not rename table
    Error code: ddltablealreadyexists
    Stack trace:

    line 500 of /lib/ddl/database_manager.php: ddl_exception thrown
    line 524 of /mod/quiz/db/upgrade.php: call to database_manager->rename_table()
    line 697 of /lib/upgradelib.php: call to xmldb_quiz_upgrade()
    line 420 of /lib/upgradelib.php: call to upgrade_plugins_modules()
    line 1615 of /lib/upgradelib.php: call to upgrade_plugins()
    line 434 of /admin/index.php: call to upgrade_noncore()

    I read suggestions elsewhere about dropping your database tables and doing a fresh install. So, that's what I did. I dropped all of my database tables and did a new install of 2.7. After that, I restored my database to the backup that I had taken. Unfortunately, all that did was take me back to where I started - I had to go through the PHP check and then the plugins check again and then it wanted to update the database.

    I have also tried updating to the newest version of 2.6 (build 20140814) and that was successful. Then I attempted to upgrade to 2.7 from there, but I ran into the same error message.

    What can I do to finally get my site updated to 2.7?
  • Noritaka Yoshida
    Wed, 3 Sept 2014, 12:55 PM
    I resolved my "duplicate last column header" problem.
    I was set to "jQuery" the setting of [Report table UI].
    (Default value is "Data Tables JS".
    Page path is "Home→Site administration→Plugins→ Blocks→Configurable Reports".)

    It is not a fundamental solution.
    Thank all.
  • Mateus Lopes
    Mon, 29 Sept 2014, 11:54 AM
    The latest version is not working in Moodle 2.7.2, please check takes a lot to some reports. Thank you
  • Nano A
    Wed, 8 Oct 2014, 11:52 AM
    Hello Juan,

    Moodle just forced me to update your plugin so I did, but it doesn't want to update. It shows this error (I'm using Moodle 2.7)

    Any ideas on what can I do?

    Thanks,


    Invalid file 'bootstrap-hover-dropdown.js' specified in jQuery plugin 'hoverdropdown' in component 'theme_gourmet'
    line 508 of /lib/outputrequirementslib.php: call to debugging()
    line 158 of /theme/gourmet/lib.php: call to page_requirements_manager->jquery_plugin()
    line 531 of /lib/outputlib.php: call to theme_gourmet_page_init()
    line 800 of /lib/outputrenderers.php: call to theme_config->init_page()
    line 2577 of /lib/outputrenderers.php: call to core_renderer->header()
    line ? of unknownfile: call to core_renderer->fatal_error()
    line 1639 of /lib/setuplib.php: call to call_user_func_array()
    line 362 of /lib/setuplib.php: call to bootstrap_renderer->__call()
    line 362 of /lib/setuplib.php: call to bootstrap_renderer->fatal_error()
    line 1187 of /lib/upgradelib.php: call to default_exception_handler()
    line 1627 of /lib/upgradelib.php: call to upgrade_handle_exception()
    line 434 of /admin/index.php: call to upgrade_noncore()

    Plugin "mod_reports" is defective or outdated, can not continue, sorry.

    More information about this error
    Debug info: Missing version.php
    Error code: detectedbrokenplugin
    Stack trace:
    line 591 of /lib/upgradelib.php: plugin_defective_exception thrown
    line 420 of /lib/upgradelib.php: call to upgrade_plugins_modules()
    line 1615 of /lib/upgradelib.php: call to upgrade_plugins()
    line 434 of /admin/index.php: call to upgrade_noncore()


  • Juan Leyva
    Wed, 8 Oct 2014, 3:38 PM
    Hi Nano,

    that error is about the mod_reports plugin that is a different plugin that configurable reports
  • Nano A
    Wed, 8 Oct 2014, 3:44 PM
    I found the error! Thanks for responding smile
Please login to post comments