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:
13438 sites
3k downloads
443 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

Show comments
  • Ken Farrimond
    Wed, 21 June 2023, 11:23 PM
    Just to clarify. We have configurable reports working well on Moodle 4.1.1 with php version 7.4.33. We have not tried it on 8.x and would like to know if it will work.
  • Fabian Glagovsky
    Thu, 24 Aug 2023, 3:39 PM
    Hi Ken,
    We also have it running in Moodle 4.1.3, PHP Version 8.0.30. Seems to work well.
  • Julio Cesar Bonilla Pardo
    Sat, 16 Sept 2023, 7:13 AM
    Hi, can someone help me adding user custom fields to reports with SQL. I have the fields Position, Company, Process and I have not been able to add them in my SQL reports.

    When I create the report adding the columns without SQL, yes I can add the user custom fields, but it does not show me the final course grade even though I add showgrades as a column.

    Thanks
  • Michael Milette
    Sat, 28 Oct 2023, 12:13 AM
    Hi Juan and Sara,

    Do you have any thoughts on when a Moodle 4.3 compatible version might become available?

    Best regards,

    Michael Milette
  • Wynand Louw
    Sun, 17 Dec 2023, 7:03 PM
    Looks like it is abandoned.
  • Halie Carton
    Tue, 9 Jan 2024, 4:53 AM
    Hello Juan and Sara,

    Has this plugin been abandoned? I'm just curious if a Moodle 4.3 compatible version will be available some time in the future.

    Thanks!

    Sincerely,
    Halie Carton
  • Juan Leyva
    Tue, 9 Jan 2024, 7:25 PM
    Hi, there is some ongoing work to make it Moodle 4.x compatible, see https://github.com/jleyva/moodle-block_configurablereports/issues/241
  • Javier Pardo
    Tue, 7 May 2024, 5:46 PM
    Hello, I'm glad to see that after a long time a version 4.1.0 (2023121803) compatible with Moodle 4.0, 4.1 and 4.2 has been released.

    Can it also be installed on Moodle versions 4.3? I understand that the requirements for version 4.2 do not differ from those of 4.3. Am I wrong?

    If it is not possible to install this plugin in versions 4.3 of Moodle, is there a plan to update for versions 4.3 in the future?

    Thank you very much for your work with this wonderful plugin.


    Muchas gracias de antemano.
  • John Leggett
    Tue, 7 May 2024, 11:48 PM
    In the past few minutes, I have installed the latest version (4.1.0) of Configurable Reports.

    Whilst all my SQL Reports are working fine, accessing all my Users Reports now crashes my Moodle site with a 'This page isn’t working - HTTP ERROR 500?' The Users Reports worked fine with the previous version of the plugin?
  • Melvyn Gomez
    Tue, 4 June 2024, 2:17 AM
    I think the new version has a bug, the SQL is working and showing the results in the screen correctly with some filters applied, but at the moment to export the report, the filters are not counting
  • Joan Cervan
    Wed, 5 June 2024, 2:57 AM
    Hi Melvyn, I'm not sure if mine is the same issue as yours. In my case, when exporting to a file, the results shown are the course #1 , and not of the course I'm trying to export the results.
  • Melvyn Gomez
    Fri, 7 June 2024, 1:09 AM
    exactly Joan, is the same issue, there is a pull request to fix that issue https://github.com/jleyva/moodle-block_configurablereports/pull/248
  • Joan Cervan
    Fri, 7 June 2024, 2:44 AM
  • Zoran Jančić
    Tue, 16 July 2024, 6:07 PM
    Any chance to prevent initial load in SQL reports so user has to apply filters before executing query? This is huge issue with reports that use filters. There is existing pull request on this issue from Sep 13, 2022
    https://github.com/jleyva/moodle-block_configurablereports/pull/217
  • Humberto Moreno
    Fri, 19 July 2024, 12:56 AM
    Someone try to install in 4.3.x? its works ?
Please login to post comments