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?
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.
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
|Asked: 9/17/14, 5:39 PM|
|Seen: 619 times|
|Last updated: 3/16/15, 8:10 AM|