Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Is there any caveats to creating reports directly from the Postgres Database?

Nate Foster
on 9/17/14, 5:39 PM 574 views

All the reporting solutions I've tried thus far have either not worked or have been overly complicated.  My next thought is to simply build by reports directly off of the PostgresDB using tools I'm familiar with.  

Has anyone done this before and is there anything I should be aware of? 







| 5 3 6
Jakarta, Indonesia
On 9/18/14, 3:19 AM

Nate,  OpenERP does have modules that use reporting engine that connects directly to PostgreSQL DB instead of going through OpenERP.  jasper_report module provides the integration with Jasper Report (we have modifications made to make it work in 7.0), pentaho_reports module with Pentaho Server.

All direct reporting solutions, in my view, suffers from authorization problem, i.e.  the access control list and record rules (and any other security related setting) does not apply.  Hence the user running the report may see data that in OpenERP they do not have access to.

Direct reporting solution will open another connection to the database.  You need to account for it when configuring PostgreSQL.

Thanks John Doe, Thus far, I've been able to build a very basic report in Pentaho and using the OpenOffice Designer. Jasper however has me stumped when it comes to the "Create Data Template 7.0" screen in OpenERP 7. The buttons do not seem to work properly, as well as it is not very clear what the Data Template is and how to properly set it up. Your right, Direct Reporting can be a security problem, however, it would be a stop gap measure until I've got Jasper figured out.

Nate Foster
on 9/19/14, 4:08 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 9/17/14, 5:39 PM
Seen: 574 times
Last updated: 3/16/15, 8:10 AM