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.
10582 sites
4k downloads
323 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

Comments

  • Ben Haensel
    Tue, Aug 8, 2017, 7:46 PM
    @Ken Thanks for sharing this! This was very slick. I removed one parenthesis from your statement and the double quotes and it worked then.

    u.id=(if(length(%%FILTER_VAR%%) >=1, if(length(%%FILTER_VAR%%) <6,cast(%%FILTER_VAR%% As Decimal),1), 1))

    Thanks again! Cheers. -Ben
  • Picture of F G
    Thu, Aug 10, 2017, 11:42 PM
    Hello,

    Is it possible to get the sql query of Course Completion? I want to create a report that shows a summary of the training program (username and completion status of each course). The report has a "Details" Button that should show additional course information (task completed etc).

    Any idea if this can be achieved through custom reports?
  • Picture of James McLean
    Fri, Aug 18, 2017, 1:48 PM
    @ben @ken - That code is still vulnerable to SQL injection. Do not use it.
    Make sure you use the parameterised queries which are built into Moodle, and the correct variable type with optional_param()/required param() for your URL arguments and then you'll be safe.
  • Picture of Przemek Kaszubski
    Fri, Aug 18, 2017, 7:35 PM
    Dear Juan, It would be great to see officially that this plugin works OK in Moodle 3.2. I can see some positive tests were made. We've been using it up to Moodle 3.0 so far, but a recent update to Moodle 3.2+ has caused our server admins to drop support for this plugin sad
    Many thanks in advance,
    Przemek
  • Picture of Megu G.
    Wed, Aug 23, 2017, 8:07 PM
    I am using Moodle 3.3.1+ (Build: 20170714). Is this version supported?
  • Picture of Amanda Doughty
    Wed, Sep 6, 2017, 10:46 PM
    I have run PHP 7 tests on the code and I get a number of errors. When will this plugin be fit for PHP 7?
  • Picture of Melisa Gordillo
    Fri, Oct 13, 2017, 12:13 AM
    Hi! Have you thought about updating the plugin to version 3.3? Tthis plugin is really useful.
  • Picture of JPInnovandoweb JPInnovandoweb
    Sat, Oct 14, 2017, 5:05 AM
    Hello my frend, one question, the plugin will have continuity
  • Picture of Javier Herrán
    Fri, Oct 20, 2017, 4:02 AM
    Buen dia Juan,

    Me gustaría saber si este proyecto tendrá continuidad para la versión 3.3 ya que se están presentando algunos inconvenientes cuando se realiza la instalación sobre esta.
    Gracias por tu pronta respuesta.
  • Picture of Martin Greenaway
    Fri, Nov 10, 2017, 6:37 PM
    What technically is the issue with 3.3 for this plugin? We have always used this plugin but obviously if it's not going to be supported going forwards we're going to have to find another solution.
  • Picture of Sameh Algable
    Wed, Nov 15, 2017, 5:36 AM
    i use moodle 3.2 , could this block work with me,? becuse i read it's for 3.1
  • Picture of Teja Majety
    Wed, Dec 6, 2017, 1:28 AM
    Hi, did anyone try it on 3.3?
  • Picture of Martin Greenaway
    Wed, Dec 6, 2017, 2:14 AM
    I think people have successfully run it on 3.3, I've installed it successfully on 3.4 but that server only had custom SQL queries, not wizard queries, and didn't use graphing, so I can't vouch for 100% functionality. From the forum thread here: https://moodle.org/mod/forum/discuss.php?d=347921#p1457418 I *think* it is intended to receive a bit of love and attention Soon(tm) to bring the official compatibility up to date.
  • Picture of Lasantha Jayawardena
    Tue, Dec 26, 2017, 11:24 AM
    Is this plugin compatible with Moodle 3.4? I installed this and configured Database details. But can't see the block on my website. Can you please help me?
  • Picture of deva m
    Tue, Dec 26, 2017, 12:03 PM
    i had installed it on moodle 3.4,
    working fine
Please login to post comments