I'm using moodle 3.6.3 and configurable reports latest version as well.
We use SCORM based courses (each has a minimum of 5 modules) and with the help of this plugin i created a custom sql reports showing (name, course name, module name, progress percentage, time spent, last access date..) along with filters, however when trying to retrieve large number of rows for all users for example, the browser takes a lot of time and even crashes sometimes.
My question: is there that we can use the filter fields as a first step and once clicking apply depending on the fields of course a report would be previewed instead of showing all the values of the query and then filter? meaning choosing the filter criteria before showing the report table not vice versa or maybe choosing default values so that onload the report would show according to the default values.
If not, then can i detect that the rows or the report is too huge to be previewed so only leave the download report button and give a message like (report too big to be previewed please download to view) so i can download and check the values without previewing the report onscreen since its either taking a longgg time or crashing?
I know i can always divide the report into several reports but imagine 5000 users that means the number of rows would be a lot greater than 5000, dividing the report into 10 or 20 reports isn't practical at all.
Thanks in advance for your help.