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
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
7639
Views
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
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