Reporting tools for postresql

Question

Could you recommend a reporting solution for postgresql/django which is:

• fairly flexible and easy-to use
• can be deployed online
• is free/opensource [optional]
• output format is HTML/CSV(optional)
• users can create new reports (via SQL)
• if it can utilise underlying django's models that'd be great

Answer 1

Open Office can connect with PostgreSQL (using ODBC), OpenRPT might do your job or take a look at Pentaho.

Answer 2

BIRT (Business Intelligence and Reporting Tools) might be a good fit if you fit the Postgresql JDBC driver onto the birt-server runtime engine. Reports could be prebuilt by you (in a report designer as a plugin to Eclipse which you might use already - maybe) or ad-hoc by users via the web. Reports can be consulted via the web (with parameters etc.). Customisable all you want.

Note that BIRT is a bit Java-centric by nature (deployed on Apache Tomcat) but can be a language-agnostic perfectly fine.