Skip to Content
This question has been flagged
rmlreport
3 Replies
9439 Rodiniai
Portretas
Tanveer Singh

Our purchase order spans a number of pages. We have customized the report format using the Openoffice report plugin. However, now we find that the PO no. is printed only on the 1st page (as it is part of the report content and not the header). We need the PO number to appear on all pages.

The header and footer are configured in the Company settings so there seems to be no option there to provide any field for the particular document being printed.

Is there any way to ensure a field in the rml file generated from Openoffice comes on all the pages of the report?

Portretas
Atmesti
Portretas
Tanveer Singh
Autorius Best Answer

Am answering my own question. In Odoo 8 I added o.name to the standard report footer.

To do this, go to Settings->User Interface->Views and edit the View with the ID : report.external_layout_footer

Here add something like the following inside the <div class="footer"> tag:

<t t-if="o.name"> <span style="font-size:8pt;" t-field="o.name"/> </t>

Now whatever document (PO, Invoice, etc.) is printed, its 'name' field (normally containing the PO number/ invoice number) gets printed in the footer on all pages. Simple solution.

Portretas
Atmesti
Juliet

Hello, Would you know how to do on V17 ?
I couldn't find the view you are talking about and I tried modifying "external_layout_boxed" but nothing moved.
I would like to add this in my header or just under it.
Thanks !

Portretas
Andreas Brueckl
Best Answer

I think that with OpenOffice this is not possible. If you are directly changing the RML-Report you can try the following option:

  • Uncheck the flag Add RML Header for the report in menu Settings/Actions/Reports for the desired report. Then copy the company header into the RML file of the report and add the required field.

The problem here is that you somehow have to put the repeatIn(objects,'o') statement before the header. Do not know whether this is possible.

Portretas
Atmesti
Tanveer Singh
Autorius

Thank you Andreas. Let me try to do this. Will report back.

Portretas
JohnWang
Best Answer

I did one changing like this before for our customer, it need do some coding, add doc no variable to RML parser context, then you can change the company's header script to add the doc no variable. If you want the code or need extra help, you can contact me at newmooncn@gmail.com

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
RML report word in blocktable too long
rml report
Portretas
0
bal. 17
3916
rml Problem-except_orm: ('', (<type 'exceptions.AssertionError'>, AssertionError(), <traceback object at 0x242C6788>))..any help ?
rml report
Portretas
Portretas
1
bal. 17
5154
printing sequence in rml surprises me
rml report
Portretas
Portretas
2
lapkr. 15
5682
Printing html field in rml report with its formatting
rml report
Portretas
0
kov. 15
5430
Cant export to RML using OpenOffice
rml report
Portretas
Portretas
1
kov. 15
5995