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.


Reports to excel with ODBC, queries and database schema?

Mark Leemans
on 9/24/15, 3:38 AM 480 views

Hello, we use Odoo in our business unit but have to deliver reports (with pivot tables with the original data / graphs etc) to the management. I want to use data from the database to generate reports in Excel. (Salespipeline and timesheets per month.)

Does anyone have any queries and/or the database schema to do this? I've already established an ODBC connection to the database (read-only) and found a schema on useopenerp.com but its not very usefull for this particular case. 

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/24/15, 3:38 AM
Seen: 480 times
Last updated: 9/24/15, 3:38 AM