Configurable Reports

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

@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

Hi am getting "Error reading from database" when a click on view report. I am using moodle 3.8 .

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

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?

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.

Done, Sara. Thanks for the redirect. A video or two would be nice though.

@Troy, I would suggest sending your question to the community forum (which is the best place to send this kind of questions): http://moodle.org/mod/forum/view.php?id=7979
Besides, there, you'll be able to add some screenshots and more information TIA!

It would be REALLY great if someone just made a video of this plugin being installed-doing its thing-etc. Just please don't film it eating ice cream or running from the police. Thanks.

Thanks for your reply Miguel! It happens when I attempt to configure a report. For example, I choose to create a new Users Report. I choose 10 for Pagination, the Javascript ordering tick, the run from remote db, as well as export to csv. On the next page, I choose User statistics, then "logins in the platform". I name the column Col001, then hit Add. White screen of death anyone else? Another scenario is I choose to NOT run from remote db then on the next page choose only User course completion status. The screen immediately jumps to white blank before I can even hit Update. Please help.

Hi, @Troy May. According to my experience, that error could be because of a wrong query result. This amazing plugin sometimes does not work properly if there is any problem with the dataset obtained from SQL.
Have you tested your query out of Moodle (e.g. MySQL browser) and/or with different datasets?

What doe it mean when you are configuring a report and it leads to a white blank page?

I too use and love Configurable Reports. I would probably say that the design of Moodle, which uses a great database and has a great database table structure, and that one who knows SQL can do almost anything they want to do, is what your comment suggests to me. Configurable Reports provides a very nice front end to the Moodle database, with many great features. SQL was developed by Codd back in the late 1960's. His concept was, and still is, great.

I too use and love Configurable Reports. I would probably say that the design of Moodle, which uses a great database and has a great database table structure, and that one who knows SQL can do almost anything they want to do, is what your comment suggests to me. Configurable Reports provides a very nice front end to the Moodle database, with many great features. SQL was developed by Codd back in the late 1960's. His concept was, and still is, great.

The "Configurable reports" plugin is absolutely superbe. Sometimes a simple line of SQL can do wonders. I am currently running an e-course over 30 weeks. Each course week contains 3 - 4 quizes that need to be passed with at least 80 %. Then the week is passed in a binary fashion - either passed or not passed. Students have to pass all 30 days. I had trouble implementing this simple algorithm in standard Moodle. However, a relatively simple custom SQL query with the "Configurable Reports" plugin did the trick for me. To me, this was the ultimate proof of the supreme power of an open source learning management system.