reports in drupal

Question

What is the best way to generate reports and view them in drupal6?

Answer 1

If you want to make something very specific and with graphics, the easiest solution is probably to create your own module. All you really need to do is to grab the data from the database and theme it however you like. This requires some Drupal knowledge, but can be done pretty fast if you know what you are doing.

Answer 2

Depending on what you want to accomplish you could use the views bonus back to create views that export as csv. If you you need charts and such you can just build a xls that pulls the data from the csv and creates the charts within the excel. I use something similar for some simple reporting.

http://drupal.org/project/views_bonus