Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
reportsBinaryv18
2 Odgovori
186 Prikazi
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
Opusti
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
Opusti
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
Opusti
Related Posts Odgovori Prikazi Aktivnost
Where is the PDF Partner Ledger QWeb Report and View in Odoo Online?
v18
Avatar
Avatar
1
dec. 25
3352
Change Sign & Pay Button on Quotation E-mails
v18
Avatar
Avatar
Avatar
Avatar
3
nov. 25
595
Problem including JS asset in v18
v18
Avatar
Avatar
Avatar
3
nov. 25
8986
Code for page number in Body of Pdf report
reports
Avatar
Avatar
Avatar
2
okt. 25
3407
How to increase the width of a column on odoo quotation PDF?
reports
Avatar
Avatar
1
okt. 25
1253