Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I implemented some view using filters and i wrote the SQL query based on filters and get the results. now i want display the query result in to PDF&Excel format how can i achieve this
please help me .......
( i.e: I am getting data from SQL query,how can generate report PDF& Excel format using that data)
what are possible solutions for this...
please suggest me ....
@chirra
Create a new transient model with fields that match the SQL query, set _auto = False, _table to a table value and create an SQL View named like the table using the SQL query. Make sure that your query returns an unique id field. In the init method of that model create the SQL view using the cr parameter as db cursor. Use that model for your report data
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
