I need a report using an sql query, the query is already created. How do I add the query or how do I create the button to generate the report?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- 회계
- 재고 관리
- PoS
- Project
- MRP
For Qweb Reports:
1- http://learnopenerp.blogspot.com/2016/09/how-to-create-custom-reports-in-odoo.html
2- http://learnopenerp.blogspot.com/2016/11/how-to-create-qweb-reports-in-openerp.html
For Jasper Reporting:
1- https://old.reddit.com/r/JasperReporting/
Hi,
Try to visit the following links
You can write your query inside the function _get_report_values . For more reference you have examples in the odoo itself like printing invoice report from button etc..
1. https://www.cybrosys.com/blog/qweb-reports-in-odoo12
2.https://www.cybrosys.com/blog/qweb-reports-in-odoo-v10
Hope it helps