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.
7114 sites
3k downloads
268 fans
Moodle 3.0, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7

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 Richard Bergemann
    Mon, Aug 12, 2019, 9:38 PM
    Is there any update on the Templates bug? Like a timeline or anything?
  • Picture of T JR
    Fri, Sep 13, 2019, 1:33 AM
    Could anyone kindly recommend an SQL developer who could help build a dashboard of reports for our Moodle implementation using this plugin? It is fully configured, I just need help realising its potential and I would prefer a referral than finding someone of Freelancer. Please feel free to message me privately.
  • Picture of SUNRISER SETH
    Wed, Sep 25, 2019, 7:02 PM
    I need an academic plugin for Moodle 3.7 that will take in calculations the promotions (that are formed from 3 universitary years, i.e.: univ. years 2019-2020, 2020-2021, 2021-2022 will make part from promotion 2019-2022), the universitary years like in above example, courses from universitary years by semesters and users that access/have activities (or not) on that courses. Reports that I need to display and save in csv, MS Excel or pdf are: Numbers of courses per semester in a selected universitary year from a selected promotion, how much users participate/had activities on each course, role (student, teacher, etc.), and of course in a timeline. The plugin would be great if will work with already acumulated logs.
    Can anyone help me with that? This plugin can be customized to do what I need?
  • Picture of Miguel González Laredo
    Thu, Sep 26, 2019, 1:12 AM
    Hi Sunriser. I think this is a plugin properly for doing that. One doubt about your requirements is what does it mean "work with already acumulated logs"... Have you got some special LOG tables different to the "official" ones? If so, maybe the challenge would be a little bit more complex, but anyway possible. This is my opinion.
  • Picture of SUNRISER SETH
    Thu, Sep 26, 2019, 9:41 PM
    Hi,

    I need an academic plugin for Moodle 3.7 that will take in calculations
    the promotions (that are formed from 3 universitary years, i.e.: univ.
    years 2019-2020, 2020-2021, 2021-2022 will make part from promotion
    2019-2022), the universitary years like in above example, courses from
    universitary years by semesters(sem.1, sem.2) and users that access/have
    activities (or not) on that courses.

    Reports that I need to display and save in csv, MS Excel or pdf are:
    -Numbers of courses per semester in a selected universitary year(i.e.:
    2019-2020) from a selected promotion (i.e.: 2019-2022), how much users
    participate/had activities on each course, role (student, teacher, etc.),
    and of course in a timeline (from beginning of logs until present day).
    The plugin would be great if will work with already acumulated logs.

    Can anyone help me with that? This plugin can be customized to do what I
    need?

    Of course I need that graphics displayed to be in form of bars & pie for
    an unadvised audience.

    @ Mr. Miguel González Laredo

    I installed Moodle in october 2018 and from then we had various activities and in its logs/journals are recorded that informations until in present day, now from the beginning I opted to save logs in files on hardisk, NOT IN DATABASE.

    I hope to fully clarify you this answer.
  • Picture of Brandon Jimenez
    Thu, Sep 26, 2019, 10:24 PM
    Hello @SUNRISER SETH

    The main purpose of this plugin is to make SQL queries that could potentially be exported as reports. Since you have those logs stored in external files, that can't be done directly. that being said, maybe you could create a new logs table in the DB and then create a SQL report. If done properly, i think it could give you the desired results. Other than that, custom plug-in is your answer.
  • Picture of Luis Oyola
    Thu, Oct 17, 2019, 10:38 AM
    Hello and thank yall for making this plugin. I am currently having our Moodle admin install this plugin to our server and by the looks of it, this seems to be able to do everything we would like. My only question is concerning surveys / questionnaires. Will this plugin allow us to be able to create reports for surveys / questionnaires?
  • Picture of Martin Greenaway
    Thu, Oct 17, 2019, 4:32 PM
    I think it's fair to say that, if the data is in the Moodle database, then you can report on it with Configurable Reports. You just need to know how to get at the data. There are no built in report templates for activities like surveys and questionnaires. Just to say, those activity modules do have their own reporting capabilities for users with elevated rights in the courses in question, though.
  • Picture of sudvej sudvej
    Fri, Oct 18, 2019, 3:34 PM
    Good day,

    I would have a query for this filter %% FILTER_COURSEMODULEFIELDS%. Does anyone know its exact syntax in SQL? I try to integrate it into the SQL query, but after entering the filter nothing happens at all. Specifically, I would need to filter out all users by institution. I use the Configurable Reports module.

    Thank you for your help.
  • Picture of Simon Davies
    Thu, Oct 24, 2019, 4:23 PM
    Subj. Custom template bug in latest version.

    Not sure if this is the correct place to message this but I'm really enjoying the flexibility of this tool but I believe there is a bug in the latest version whereby choosing custom template simply generates the following in the report view:

    ArrayArrayArrayArrayArrayArrayArray

    Is this correct?
  • Sketch...
    Thu, Oct 24, 2019, 9:22 PM
    Simon, you should rather search and post in the forum: https://moodle.org/mod/forum/view.php?id=7979

    See if the solution on https://tracker.moodle.org/browse/CONTRIB-7786 works for you.
  • Sketch...
    Thu, Oct 24, 2019, 11:01 PM
    Simon, you should rather search and post in the forum: https://moodle.org/mod/forum/view.php?id=7979

    See if the solution on https://tracker.moodle.org/browse/CONTRIB-7786 works for you.
  • Picture of Jonny Galvez
    Wed, Nov 13, 2019, 7:29 PM
    We are having an issue with the user module outline stats where the report is returning that a user has been started but not yet completed, despite the user having completed the element. This seems to be happening inconsistently.

    Do you have any suggestions on how we can fix this? We find this plugin extremely valuable when it's returning the correct completion status.
  • Picture of Brandon Jimenez
    Wed, Nov 13, 2019, 11:38 PM
    @Jonny Galvez: A couple of questions, are you having an issue just with a single user in a single activity in a single course, or is it more an issue with the activity and the completion settings. And, have you tried running the query directly on Maria/MySql?
  • Picture of Madhu Avasarala
    Thu, Nov 21, 2019, 4:13 AM
    There is a problem with Moodle Site Admin menu on Moodle 3.8 with this plugin verion 3.7.0 (corresponding to MOODLE_36_STABLE branch on GitHub). Presumably, improper javascript isues caused by this plugin is preventing javascript of Moodle Core to be properly executed. Please see bug tracker: https://tracker.moodle.org/browse/CONTRIB-7909
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Please login to post comments