Skip to Content
This question has been flagged
qwebreportingreportodoo16features
1 Reply
4524 Views
Avatar
Rithik Sandron

Hi,

I want to generate a custom PDF report with custom data fetched from a python method called from a button in a Wizard.

Report Template:


---------

Python Wizard Method:

from odoo import fields, models, api

class TDSReport(models.TransientModel):
	​_name = 'tds.report.wizard'

	​user_id = fields.Many2one('res.users')
	​from_date = fields.Date()
	​to_date = fields.Date()

	​def generate_report(self):
	​	​for record in self:
	​	​	​custom_records = self.env['user.payment.tds'].search([domain])
	​	​	//generate tds_report_document with custom_records data​

Thanks for the help

Avatar
Discard
Rithik Sandron
Author

Report Template:

<template id="tds_report_document">
----------------
</template>

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

Under specific circumstances, we must print the report using a wizard or button. In that case, we execute the report action from the earlier example using the print button inside the wizard or form.

This generates a report by executing a custom SQL query to retrieve truck booking data based on specific criteria.

def generate_report(self):

        query = """xxx """

        if self.from_date:

            query += """ where tb.date >= '%s' and tb.date

        self.env.cr.execute(query)

        report = self.env.cr.dictfetchall()

        data = {'date': self.read()[0],'report': report}

        return self.env.ref('module_name.action_report_booking').report_action(None, data=data)


For more info, please refer to the blog https://www.cybrosys.com/blog/how-to-create-pdf-report-in-odoo-16

Hope it helps,

Avatar
Discard
Related Posts Replies Views Activity
I`m trying to create a qweb pdf report in odoo 16 community version. But I got error: AssertionError: Call _get_view_id, expected 'ir.ui.view', got 'ir.actions.report'
error qweb reporting report odoo16features
Avatar
0
Oct 23
3
I`m trying to create a qweb pdf report in odoo16 community version but I got an error: AssertionError: Call _get_view_id, expected 'ir.ui.view', got 'ir.actions.report' Solved
qweb reporting odoo16features
Avatar
Avatar
Avatar
3
Aug 24
4218
Set a div element always at the bottom of the QWEB report, not "footer"
qweb report odoo16features
Avatar
0
Aug 23
2511
How to give automatic height to my qweb report?
qweb report odoo16features
Avatar
Avatar
1
Jul 23
3090
[SOLVED]Retrieving the product template linked to a variant selected in treeview Solved
qweb reporting report
Avatar
Avatar
Avatar
3
Mar 18
8816