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,