How to add data from different models in a report?

Question

Hi, I've made a custom module with two models and I've then installed the Base Report app (report_xlsx module) from OCA and I've made a report for one of the models. If done in this way, the report works: I select the records of the model that I want to see in the file and then select print, and the file xlsx shows up correctly.
What I would like to do now is to export in the same report file all the records of the other model: how could I do it?
Thanks

Lawrence · Answer

you can use self.env['other.model'].search()
and add it in a list.
just like
your_list = []
for x in self.env['other.model'].search([your_condition_here])
vals = {
}
your_list.append(vals)
and then add your_list in your context

相關帖文	回覆	瀏覽次數
Insert image in excel using xlsxwriter class. Odoo16 已解決 report xlsx odoo xlsxwriter	1 5月 23	3891
Print Excel Report, the use of partner_xlsx('report.res.partner.xlsx', 'res.partner') report excel xlsx odoo	0 12月 22	4360
How can I create and save a report in the attachments? report odoo	0 9月 24	1330
Export XLSX in Odoo 16 xlsx odoo	0 5月 23	66
Odoo Report - getting currently singular active ID report odoo	0 3月 18	3467

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！