Python Reporting

Question

Are there any packages that provide to following:

1. Integration with python application with minimal dependencies (beyond existing depends we use such as wx and matplotlib)
2. Visual design tool to make it easier for less technical users to design their own reports
3. Able to work with MySQL and Oracle databases
4. Cross platform (Linux and Windows), though this shouldn't be an issue for a python package

The following are pluses but not necessary:

1. Web based software for serving reports, also scheduling delivery via multiple methods such as email
2. Standards based, reports are not a proprietary binary file format
3. Reports can be saved in multiple formats (pdf, html, etc)

Answer 1

What platform does it need to run on? Windows?

Off the top of my head, reporting tools such as Crystal Reports (commercial), SQL Server Reporting Services (commercial), Jasper Reports (commercial, open source), Pentaho Reporting (commercial, open source) that do #2, #3 and pluses.

Depending on your python application, you may not need a python version of these reporting tools. You could package your python app as a com service or integrate using language bindings (JPython for instance).

Answer 2

To make working on more than one type of DB easy in python you should think about sqlalchemy. Write code once, and will work on several DB :)

Answer 3

From your description it sounds like you're looking for Eclipse [BIRT] (http://www.eclipse.org/birt/phoenix/). It's not written in Python but could be easily integrated with your python application

Answer 4

You might want to check out Dabo.