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: 5 days

13590 sites

4k downloads

437 fans

Current versions available: 6

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

Early bird 3.10

Comments

Adam Shearman
Wed, 22 Jan 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, 23 Jan 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, 23 Jan 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, 5 Feb 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, 6 Feb 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
salvatore salvatore
Fri, 27 Mar 2020, 11:16 PM
Hi, it is not clear to me if in the plug-in settings I have to set the following fields:
Host DB
block_configurable_reports | dbhost

DB name
block_configurable_reports | dbname

Username DB
block_configurable_reports | dbuser

DB password
block_configurable_reports | dbpas

This question arises because in the column section, when I choose to add a column the fields 'Report' and 'Column' remain empty do not make me choose any field.
Thanks.
Salvatore Campitiello
Martin Greenaway
Fri, 27 Mar 2020, 11:36 PM
Hi Salvatore, Those fields only need to be filled in if you are running reports against a different database from the standard one your moodle is using - for example, if you have a reporting replica DB to keep the load on the main DB down.
Martin Greenaway
Fri, 27 Mar 2020, 11:39 PM
Hi Salvatore, Those fields only need to be filled in if you are running reports against a different database from the standard one your moodle is using - for example, if you have a reporting replica DB to keep the load on the main DB down.
salvatore salvatore
Fri, 27 Mar 2020, 11:55 PM
Could you tell me why in the column section, when I choose to add a column, the fields 'Report' and 'Column' remain empty do not make me choose any field.
I chose a Timyline report
Thanks.
Salvatore Campitiello
salvatore salvatore
Fri, 27 Mar 2020, 11:59 PM
Could you tell me why in the column section, when I choose to add a column, the fields 'Report' and 'Column' remain empty do not make me choose any field.
I chose a Timyline report
Thanks.
Salvatore Campitiello
salvatore salvatore
Sat, 28 Mar 2020, 12:01 AM
Could you tell me why in the column section, when I choose to add a column, the fields 'Report' and 'Column' remain empty do not make me choose any field.
I chose a Timyline report
Thanks.
Salvatore Campitiello
salvatore salvatore
Sat, 28 Mar 2020, 12:04 AM
Could you tell me why in the column section, when I choose to add a column, the fields 'Report' and 'Column' remain empty do not make me choose any field.
I chose a Timyline report
Thanks.
Salvatore Campitiello
Martin Greenaway
Sat, 28 Mar 2020, 12:05 AM
I don't know I'm afraid, we don't use Timeline reports.
salvatore salvatore
Sat, 28 Mar 2020, 12:09 AM
Could you tell me why in the column section, when I choose to add a column, the fields 'Report' and 'Column' remain empty do not make me choose any field.
I chose a Timyline report
Thanks.
Salvatore Campitiello
salvatore salvatore
Sat, 28 Mar 2020, 12:12 AM
Could you tell me why in the column section, when I choose to add a column, the fields 'Report' and 'Column' remain empty do not make me choose any field.
I chose a Timyline report
Thanks.
Salvatore Campitiello