Simple Django Report Generator

Patrick McDonnell

unread,

Mar 10, 2011, 8:24:37 PM3/10/11

to django...@googlegroups.com

Hello -

I'm wondering if anyone has any suggestions/recommendations for a flexible Django report generator. Basically, I'd like to give user's the ability to query a given model based on user-defined filters. For example, for an application that tracks information about a company's employees, often a manager will want to run a report saying "show me all the employees in the accounting department who have been employeed for X or more years," or something to that effect. Clearly, these kind of reports are trivial for me to hard code using Django's ORM, but a much more ideal solution would be to provide users with a (dare I say it) MS Access-like query builder, that would allow them to choose the columns they want, define basic filters, and a sorting order, and then review the results in a tabular format.

I've looked around and haven't quite found anything that meets my needs, so I'd appreciate any suggestions anyone might have. If nothing exists, I'll probably try to write something myself, and make it my contribution to the OSS community if its any good, but obviously I'd rather not reinvent the wheel.

Thanks in advance!

Venkatraman S

unread,

Mar 10, 2011, 9:44:10 PM3/10/11

to django...@googlegroups.com

On Fri, Mar 11, 2011 at 6:54 AM, Patrick McDonnell <kc9...@gmail.com> wrote:

Clearly, these kind of reports are trivial for me to hard code using Django's ORM, but a much more ideal solution would be to provide users with a (dare I say it) MS Access-like query builder, that would allow them to choose the columns they want, define basic filters, and a sorting order, and then review the results in a tabular format.

I have done earlier, wherein i had to design a custom dashboard for reporting.
Instead of the ORM, think in terms of building a SQL - things would be much much easier and also faster to develop.

-V