Blocks: Configurable Reports

block_configurable_reports
Maintained by Picture of Juan LeyvaJuan Leyva, Picture of Sara Arjona TéllezSara 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

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

Picture of Juan Leyva
Juan Leyva (Lead maintainer)
Picture of Sara Arjona Téllez
Sara Arjona Téllez: Developer
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Picture of Lyrics IN Backlinks
    Tue, Dec 24, 2019, 9:54 PM
    Nice one
  • Picture of 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.
  • Picture of 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.
  • Picture of 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.
  • Picture of 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?
  • Picture of 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?
  • Picture of 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.
  • Picture of 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.
  • Picture of 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 wink TIA!
  • Picture of Troy May
    Wed, Jan 15, 2020, 9:53 PM
    Done, Sara. Thanks for the redirect. A video or two would be nice though.
  • Picture of 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.
  • Picture of 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?
  • Picture of 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
  • Picture of 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 .
  • Picture of 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