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

Show comments
  • Fabian Glagovsky
    Thu, May 18, 2023, 7:25 PM
    Hi Juan, thank you a lot for replying. I have installed a XAMP version of Moodle 4.1 in my Windows pc, it says the PHP environment is 8.0.28 and managed to install Configurable Reports without any issue, and it seems it works fine.
    If there is need to update it, where would you focus? on UX or do you think the code might have issues in 4.1? Because if it works, let's not jinx it smile

    "Configurable Reports, can we trust him?"
    Batman
  • Fabian Glagovsky
    Thu, May 18, 2023, 7:26 PM
    And thank you Nat, I did test it successfully, as you can see. Thank you for giving me the idea!
  • Sohail Bhana
    Thu, May 18, 2023, 8:03 PM
    @Nat Saur & Fabian Glagovsky

    If you could please post your method and findings in the Support Forum (https://moodle.org/mod/forum/view.php?id=7979) that would be a great help and appreciated by us all I'm sure smile

    Thank you
  • Fabian Glagovsky
    Thu, May 18, 2023, 9:13 PM
    Done, check it.
    https://moodle.org/mod/forum/discuss.php?d=444916#p1795847
    Regarding how to install Moodle 4.0 in your laptop, see my video
  • Ken Farrimond
    Mon, Jun 19, 2023, 5:06 PM
    Hi Juan and Sara
    We use configurable reports very heavily, and have it working well on our test site upgraded to 4.1. However obviously we would prefer that the plugin was properly upgraded to 4.1 as there could be unforeseen issues. We do have some funding available to help with this. Do you know of any experienced Moodle developers who might be willing to take up this upgrade? Please do put them in touch with me.
    Ken
  • Gareth J Barnard
    Mon, Jun 19, 2023, 8:23 PM
    Dear Juan,

    I'm interested when you say that the migration to 8.2 will be a lot of work? I've looked at https://www.php.net/manual/en/migration82.php and wondered why?

    Thanks,

    Gareth
  • Ken Farrimond
    Wed, Jun 21, 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, Aug 24, 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, Sep 16, 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, Oct 28, 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, Dec 17, 2023, 7:03 PM
    Looks like it is abandoned.
  • Halie Carton
    Tue, Jan 9, 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, Jan 9, 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, May 7, 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, May 7, 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?
Please login to post comments