Skip to Content
This question has been flagged
reportsBinaryv18
2 Replies
173 Views
Avatar
Boris Giordanengo 
Hello,

I have an xml file to generate a report a my.model:

<odoo>
    <template id="my_template">
        <t t-call="web.html_container">
            <t t-foreach="docs" t-as="o">
               My report
            </t>
        </t>
    </template>

    <report id="my_report" model="ir.actions.report">
        <field name="name">Report</field>
        <field name="model">my.model</field>
        <field name="report_type">qweb-pdf</field>
        <field name="report_name">my_app.my_template</field>
        <field name="report_file">my_app.my_template</field>
        <field name="binding_model_id" ref="model_my_model"/>
        <field name="binding_type">report</field>
    </report>
</odoo>


This code is working file.
I also know how to generate the pdf report via a button, but I don't know how to generate this pdf report as a binary field of my.model (report_id = fields.Binary('pdf report')).

Thanks,

Boris

Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer
Hi,

You can generate a QWeb PDF report programmatically and store it in a Binary field on your model.The correct approach is to call the report action from Python, render the PDF in memory, and then write the resulting bytes to a binary field. You do not need to trigger a download or rely on a button action that returns a report.

First, define the binary field on your model:

from odoo import models, fields

class MyModel(models.Model):
    _name = 'my.model'

    report_pdf = fields.Binary(string="PDF Report", attachment=True)
    report_pdf_name = fields.Char(string="PDF Filename")

Then, generate and store the PDF using ir.actions.report. In Odoo 18, the supported API is _render_qweb_pdf:

from odoo import models, api
import base64

class MyModel(models.Model):
    _name = 'my.model'

    def action_generate_pdf(self):
        report = self.env.ref('my_app.my_report')

        pdf_content, _ = report._render_qweb_pdf(self.id)

        self.write({
            'report_pdf': base64.b64encode(pdf_content),
            'report_pdf_name': f'Report_{self.id}.pdf',
        })
This method renders the same PDF as your XML report definition, but instead of returning it to the browser, it stores it directly in the database.
Setting attachment=True on the binary field ensures the file is stored efficiently in ir.attachment and can be downloaded later. You can then expose this field in a form view to allow users to download the stored PDF.


Hope it helps

Avatar
Discard
Avatar
Jainesh Shah(Aktiv Software)
Best Answer

Hello Boris Giordanengo ,

 

Yes, you can generate a PDF report and store it in a Binary field in Odoo 18 using a custom module. You can achieve this by following the steps below

 

1) Add New Fields to Your Model

class MyModel(models.Model):

    _name = 'my.model'

   

    report_id = fields.Binary(

        string='PDF Report',

        attachment=True

    )

    report_filename = fields.Char(string='Report Filename')

 

 2) Add Button and Fields to Your Form View

           

<button name="action_generate_pdf_report"

                    type="object"

                    string="Generate PDF"

                    class="btn-primary"/>

 

3) Create the Button Action:

       Define a Python method that generates the PDF report and stores it in the Binary field

 

4) Generate and Store the PDF:

       When you click the Generate PDF button, the report will be generated and automatically stored in the Binary field as an attachment

 

This solution allows you to generate a PDF report and store it directly in a Binary field using standard Odoo functionality.


If you have any questions, feel free to reach out.

Hope this helps!


Thanks and Regards,

Email: odoo@aktivsoftware.com

Avatar
Discard
Related Posts Replies Views Activity
Where is the PDF Partner Ledger QWeb Report and View in Odoo Online?
v18
Avatar
Avatar
1
Dec 25
3347
Change Sign & Pay Button on Quotation E-mails
v18
Avatar
Avatar
Avatar
Avatar
3
Nov 25
591
Problem including JS asset in v18
v18
Avatar
Avatar
Avatar
3
Nov 25
8968
Code for page number in Body of Pdf report
reports
Avatar
Avatar
Avatar
2
Oct 25
3405
How to increase the width of a column on odoo quotation PDF?
reports
Avatar
Avatar
1
Oct 25
1251