Custom reports

a_c_m - June 11, 2009 - 17:48

Custom reports is a module for times when your client needs to export data from their Drupal site.
This module is aimed at developers.

If the data they need is a simple query your probably better off using the excelent Views module along with very helpful Views bonus pack.

Report from tables that are not yet accessible to views (and don't want to use the Table Wizard module)

Then this module might be able to help.

Custom reports uses an exsisting content type (or creates one for you)
You create a new custom report node, give it a title and paste your pre-written SQL into the body
You give the client user the correct permissions to view the report
They visit the report page, click on one of the export tabs (currently CSV and XLS, but its easy to extend) - they are then prompted to open or download the report

In the case of CSV the module will replace any " marks with ' marks, XLS does not have this problem.

- Drupal 5 release sponsored by Raw Nerve