Blocks: Configurable Reports

block_configurable_reports
Maintained by Picture of Juan Leyva Juan Leyva
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.
6583 sites
2k downloads
231 fans

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)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Picture of Ericka Zuniga
    Wed, 6 Jun 2018, 2:04 AM
    Someone knows, Is it compatible with Moodle 3.5? or when will the 3.5 version of the plugin be released?
  • Picture of Madhu Avasarala
    Wed, 6 Jun 2018, 3:51 AM
    I use it on Moodle 3.5 and it appears to be working, however this is not an exhaustive test of all its capabilities.
  • Picture of Daniël de Villiers Hugo
    Mon, 16 Jul 2018, 9:07 PM
    It looks like there might be a issue on 3.3.2 . When you change the setting of one of the reports to be a global report (accesible from any course) , and you created it in the dashboard, it does not display on course level. However, if it was created in a course, then it is displayed in the dashboard also.
  • Picture of nicholas chandra
    Mon, 23 Jul 2018, 4:56 PM
    hello, i use it on Moodle 3.5 and i love it. However, whenever i generate record , the teacher role always generated as a student. Is it a bug or what?
  • myname
    Tue, 14 Aug 2018, 3:05 PM
    I am using Moodle 3.5 , is this plugin compatible with it?
    this plugin is really great
    Thank you
  • Picture of Michael Milette
    Fri, 7 Sep 2018, 9:53 AM
    Parts of it are compatible with Moodle 3.3, 3,4 and 3.5 however there are definitely issues. For example, you can create custom SQL reports but import existing reports does not work. Creating graphs doesn't work. Icons are broken and links to stylesheets are broken.

    I fixed some of these issues in my fork at https://github.com/michael-milette/moodle-block_configurablereports/tree/MOODLE_33_STABLE which at least makes it useful in Moodle 3.3, 3.4 and 3.5. If anyone has fixes for remaining issues listed above, please share them so that we can all get this very useful plugin back into a working state.
  • Picture of Madhu Avasarala
    Wed, 12 Sep 2018, 10:39 AM
    Hi Michael, do you know if the sendemail feature is working in your fork? This is the feature where emails can be sent to selected users using the AS 'sendemail' for a column.
  • Picture of Daniel Antonio -
    Fri, 14 Sep 2018, 9:34 PM

    a suggestion for anyone who is having problems with plugin compatibility is to install moodle 3.1 on the same server and then install the plugin then you should point your sql syntax to the database of the new version of moodle. Sorry if it was not clear, I used the translator.
  • Picture of Michael Milette
    Wed, 10 Oct 2018, 9:57 AM
    Hi Madhu, I haven't tried the sendmail feature yet. The fork only includes fixes, not enhancements. I haven't touched the code for that at all. Give it a try and let us know. If it is an issue, hopefully someone will have a fix for it.
  • Picture of siham admin
    Mon, 22 Oct 2018, 7:08 PM
    Hi,

    This Plugin is really great and helpful , Thank you so much.
    But i really need to export my reports in PDF in Moodle 3.5
    HELP Please.

    Regards,
  • Picture of Madhu Avasarala
    Tue, 6 Nov 2018, 1:05 AM
    @Siham, as far as I know, it will be difficult to get a PDF export option. A solution is to upload reports onto Google Drive and provide shareable links. Google provides options for PDF download of any uploaded documents and sheets.
  • Felipe Raimo
    Wed, 7 Nov 2018, 4:36 AM
    Juan, thanks for this!!! smile
  • Picture of Rolf Petersen
    Wed, 7 Nov 2018, 3:18 PM
    Hi Juan, I want to use it on M 3.5.2 Production Site. Test in Testsite is OK so far BUT: in course Filter ALL courses on the Installation are shown in the Dropdownlist of courses (in my case more than 100!). I want only those ones to appear, where courses are within same course category where course from which is called. How can that be managed? If necessary, code change is accepted. So: course resides in category "A" (example: 7 courses in that category), Dropdown should only show these 7 courses! Please help, how can that be managed?
  • Ben Haensel
    Thu, 22 Nov 2018, 2:11 AM
    I am still using the Configurable Reports plugin yet would love to see this logic updated and added to core. If you feel the same, please take a minute to review this MUA proposal I submitted and vote it up! https://tracker.moodle.org/browse/MDL-63233

    -Ben, BlueSky Online School, MN-USA
  • Al
    Sun, 25 Nov 2018, 10:57 PM
    It does work with 3.5 as we use it. Our special needs students find it very valuable. However, if there is anyone out there that can add the moodle Auto Updater to this plugin, it would be very much appreciated as every time we update moodle we have to find this plugin and do it manually. Please someone help.
1 2 3 4 5 6 7 8 9 10 11 12 13 14

Commenting temporarily disabled