CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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.
About This Community
Odoo Training Center
|Asked: 9/17/14, 5:39 PM|
|Seen: 1008 times|
|Last updated: 3/16/15, 8:10 AM|