I'm really interested in this tool. But it can't be downloaded. Could you please fix it.

Sorry, it can be downloaded now. Could you please provide more guides on installing it?

Upload and extract the zip file to your admin/report/ directory

Go to Site Admin > Notifications

The report will be under Site Admin > Reports > Ad-hoc database queries

Thanks Tim, this is great!

Grab and Drag Resizable/Sortable columns (Javascript):

I've just added this using the dhtmlxGrid (maybe it could be done with YUI as well).

This might not work very well if you have really large resultsets.

To try it out download this file: http://moodle.org/file.php/5/moddata/forum/125/595572/codebase.zip and extract it to your admin/report/customsql/ folder.

Then add this code to view.php (around line 32)

require_js('codebase/dhtmlxcommon.js');
require_js('codebase/dhtmlxgrid.js');
require_js('codebase/dhtmlxgridcell.js');
require_js('codebase/ext/dhtmlxgrid_start.js');

around line 95 Change

print_table($table);

to:

$table->id = 'mygrid';
print_table($table);
?>
<script type="text/javascript">
var grid = dhtmlXGridFromTable("mygrid");
</script>
<?php

I'm thinking of modifying the plugin so that users can use $CFG variables in the sql queries. it would be nice if this were available.

I have installed this report plugin, but I am not seeing any results when I run a report. I am using a very basic query for testing (counting users), but when I run the report there are no results displayed - just a screen with the title of the report. When I look at the list of available report, I see that the query did run and there are no errors reported. Any idea?

Rob