Moodle plugins directory: Configurable Reports

Blocks: Configurable Reports

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.

7650 sites

2k downloads

281 fans

Current versions available: 5

Download

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.

Links

Support forum

Useful links

Screenshots

Contributors

Juan Leyva (Lead maintainer)

View other contributions

Sara Arjona Téllez: Developer

View other contributions

Please login to view contributors details and/or to contact them

Awards

Privacy friendly

Early bird 3.7

Comments

Show comments

Lyrics IN Backlinks
Tue, Dec 24, 2019, 9:54 PM
Nice one
Martin Biermann
Mon, Dec 30, 2019, 10:05 PM
The "Configurable reports" plugin is absolutely superbe. Sometimes a simple line of SQL can do wonders. I am currently running an e-course over 30 weeks. Each course week contains 3 - 4 quizes that need to be passed with at least 80 %. Then the week is passed in a binary fashion - either passed or not passed. Students have to pass all 30 days. I had trouble implementing this simple algorithm in standard Moodle. However, a relatively simple custom SQL query with the "Configurable Reports" plugin did the trick for me. To me, this was the ultimate proof of the supreme power of an open source learning management system.
Rick Jerz
Mon, Dec 30, 2019, 10:45 PM
I too use and love Configurable Reports. I would probably say that the design of Moodle, which uses a great database and has a great database table structure, and that one who knows SQL can do almost anything they want to do, is what your comment suggests to me. Configurable Reports provides a very nice front end to the Moodle database, with many great features. SQL was developed by Codd back in the late 1960's. His concept was, and still is, great.
Rick Jerz
Mon, Dec 30, 2019, 10:47 PM
I too use and love Configurable Reports. I would probably say that the design of Moodle, which uses a great database and has a great database table structure, and that one who knows SQL can do almost anything they want to do, is what your comment suggests to me. Configurable Reports provides a very nice front end to the Moodle database, with many great features. SQL was developed by Codd back in the late 1960's. His concept was, and still is, great.
Troy May
Tue, Jan 14, 2020, 5:05 AM
What doe it mean when you are configuring a report and it leads to a white blank page?
Miguel González Laredo
Tue, Jan 14, 2020, 5:04 PM
Hi, @Troy May. According to my experience, that error could be because of a wrong query result. This amazing plugin sometimes does not work properly if there is any problem with the dataset obtained from SQL.

Have you tested your query out of Moodle (e.g. MySQL browser) and/or with different datasets?
Troy May
Tue, Jan 14, 2020, 10:27 PM
Thanks for your reply Miguel! It happens when I attempt to configure a report. For example, I choose to create a new Users Report. I choose 10 for Pagination, the Javascript ordering tick, the run from remote db, as well as export to csv. On the next page, I choose User statistics, then "logins in the platform". I name the column Col001, then hit Add. White screen of death anyone else? Another scenario is I choose to NOT run from remote db then on the next page choose only User course completion status. The screen immediately jumps to white blank before I can even hit Update. Please help.
Troy May
Tue, Jan 14, 2020, 10:31 PM
It would be REALLY great if someone just made a video of this plugin being installed-doing its thing-etc. Just please don't film it eating ice cream or running from the police. Thanks.
Sara Arjona Téllez
Wed, Jan 15, 2020, 3:39 PM
@Troy, I would suggest sending your question to the community forum (which is the best place to send this kind of questions): http://moodle.org/mod/forum/view.php?id=7979

Besides, there, you'll be able to add some screenshots and more information TIA!
Troy May
Wed, Jan 15, 2020, 9:53 PM
Done, Sara. Thanks for the redirect. A video or two would be nice though.
Adam Shearman
Wed, Jan 22, 2020, 1:38 AM
Currently have JavaScript Ordering on a number of reports due to the quick sorting etc.
Only issue is that this defaults to "Show 10 entries" when loading the report. Is there a way to configure this default number as we would rather it show 50 to start of with.
Pagination does not look to be the setting to change this as the javascript sorting is then only applied to the page rather than total items.
Kashmira Nagwekar
Thu, Jan 23, 2020, 4:45 PM
Hey, I want to display configurable reports block in order to display some of the site stats without user login on site homepage. Can this be achieved?
Brandon Jimenez
Thu, Jan 23, 2020, 9:46 PM
Hello @Kashmira, a quick question: why do you want to achieve that? wouldn't that be a security risk? I'm not judging, just want to know more

Best Regards, Brandon
Kennedy Agutu
Wed, Feb 5, 2020, 9:11 AM
Hi am getting "Error reading from database" when a click on view report. I am using moodle 3.8 .
Miguel González Laredo
Thu, Feb 6, 2020, 6:37 PM
@Kennedy_Agutu, have you tested the corresponding SQL query on the Database? Maybe this link for debugging moodle queries could be useful for you https://docs.moodle.org/38/en/Debugging#Debug_SQL_queries

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Please login to post comments