I want to create a new "Business" application using the Django framework. Any suggestions as to what I can use as a reporting framework? The application will need to generate reports on various business entities including summaries, totals, grouping, etc. Basically, is there a Crystal reports-like equivalent for Django/Python?
These are just HTML templates with ordinary view functions.
This doesn't require much: Parameters come in from a form; write the query in the view function, passing the queryset to the template. The template presents the report.
Why would you need something more than this?
You can use generic list/detail views to save yourself from having to write as much code. If you go this route, you provide the query set and the template to a generic view that handles some of the processing for you.
Since you must write the query in Crystal reports or Django, you're not really getting much leverage from a "reporting" tool.
I don't know about complete reporting solution for Django (or Python), but make reporting with Django is quite easy with or without ORM:
- django-tables can give you very basic structure for handling table data (asc/desc server-side sorting etc)
- you can use standart django 1.1 queryset aggregates (django-reporting uses them) for totals/subtotals stuff.
Personally I use django-tables and neithere's datashaping python package for quick summary/avg/median/IQR/filtering stuff because I have many different data sources (REST data, two mysql dbs, csv files from R) with only few of them in django db now.
Pycha is one of candidates for me to draw simple charts.
I don't like client-side ajax-based grids etc for reporting, but you can use it with django templates too.