Easy to use graphical reporting tools for SQL

[Kevin]

In our office we have a Django application that uses a MySQL database. Often I am asked to produce various reports that can range from being basic dumps of query results or aggregate computations on query results. To do this I must connect to the Django shell to use the ORM or write the SQL directly. The problem is that it is impossible for the non-developers to access reports unless they ask a developer to create the queries, run them, and send the result back. This adds to lots of communication overhead and delays.

Is there a basic free or open-source application that can connect to MySQL and allow non-developers to graphically build their own queries?

[叶]

Maybe you can try navicat. 

http://www.navicat.com/

2015-07-21 5:09 GMT+08:00 Kevin <hekev...@gmail.com>:

In our office we have a Django application that uses a MySQL database. Often I am asked to produce various reports that can range from being basic dumps of query results or aggregate computations on query results. To do this I must connect to the Django shell to use the ORM or write the SQL directly. The problem is that it is impossible for the non-developers to access reports unless they ask a developer to create the queries, run them, and send the result back. This adds to lots of communication overhead and delays.

Is there a basic free or open-source application that can connect to MySQL and allow non-developers to graphically build their own queries?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/6ab5432b-6a89-4942-b103-ca059dceaf98%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Stefano Probst]

Know the "non-developers" SQL? I guest not, but if you can try MySQL workbench..

[Vijay Khemlani]

I guess any kind of report they want to generate will require some knowledge of relational databases.

Considering that, I think Jasper Reports is a good tradeoff, It has a graphical interface to create the queries, and the reports can be accessed by anyone after it's query and design is done.

On Tue, Jul 21, 2015 at 4:20 PM, Stefano Probst <sen...@gmail.com> wrote:

Know the "non-developers" SQL? I guest not, but if you can try MySQL workbench..

--

You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/6a7f0ba0-137a-4160-8855-a4eb2e04adc1%40googlegroups.com.

[Lee Hinde]

https://github.com/epantry/django-sql-explorer

You can build the queries and they're available to whomever you want to give access. This assumes they have access to the django app.