Configurable Reports

Does anyone have any documentation on setting up the configurable reports plugin to a remote DB? My Moodle 3.1 is running MySQL and I'm attempting to connect to another DB in our hosted environment that is running SQL Server 2008.

Hello,
Any news on version for Moodle 3.3? Tried installing and it does not work, does anyone have a workaround maybe? Thank you!

Hi Nicola, I'm writing you by inner messenger (https://moodle.org/message) to help you.

Hi to all. I have a question. I Have created a database activity in wich student insert their name, activities and hours of activity. How (with a sql query) can I get the amount of the hours for each student? Thank you very much

Hi, Is there an upgrade for moodle 3.2 or this will can work?

Hi Edmund Evangelista "Hi Juan, is there a way to modify the text of Search Text filter instead of the default text "Filter" to change it to something like "Academic Year" or any text I would want?"
Yes. Just copy a filter from the component folder, change a few variable names and update your lang/en details.

The same here. We are upgrading to moodle 3.2 version and would like to continue using this great plugin. Any previews?

Any previews for the moodle 3.2 version?

Hello! How i can change in print params Page Header & Footer (on top of page is date, at the bottom is number of page) to make my own page header on every page?

cuando quiero instalar en mi moodle version 3.0 me pide elegir la extensión y no sé que es eso y cual elegir

If moodle not installed on root of site, style.php import on lines 1 2 and 3 should be something like @import url("wwwroot/blocks/configurable_reports/js/datatables/media/css/jquery.dataTables.css");
@import url("wwwroot/blocks/configurable_reports/js/codemirror/lib/codemirror.css");
@import url("wwwroot/blocks/configurable_reports/js/codemirror/addon/display/fullscreen.css");

Any upgrade to Moodle 3.2?

Hi everybody, i have moodle 3.0.4+ version and installed configurable reports ont it (v 3.1.0). The problem i face actually is when i type this request is that only the students are reported and not the other roles like teacher, manager, ... even i've verified in moodle that everyone exist :
The request:
SELECT
user2.firstname AS Prenom,
user2.lastname AS Nom,
user2.email AS Email,
course.fullname AS Cours
,(SELECT shortname FROM prefix_role WHERE id=en.roleid) AS ROLE
,(SELECT name FROM prefix_role WHERE id=en.roleid) AS RoleName
FROM prefix_course AS course
JOIN prefix_enrol AS en ON en.courseid = course.id
JOIN prefix_user_enrolments AS ue ON ue.enrolid = en.id
JOIN prefix_user AS user2 ON ue.userid = user2.id
the result is :
1 student 2 Conformité
2 2 Conformité
3 student 2 Conformité
4 student 2 Conformité
5 student 3 Déblocage
6 3 Déblocage
7 student 3 Déblocage
8 student 4 Fermeture des caisses
9 4 Fermeture des caisses
10 student 4 Fermeture des caisses
11 student 5 test

Hi Juan, is there a way to modify the text of Search Text filter instead of the default text "Filter" to change it to something like "Academic Year" or any text I would want?

Hi Juan thanks by the way for this awesome report tool. Is there a way to add custom filters like semester (in English), academic year, department and so on? What are steps in order to push this filter to appear in the filters of configurable reports? I tried also duplicating a certain filter with another name, but I always get an error.