Skip to Content
This question has been flagged
rmlreport
3 Replies
8213 Views
Avatar
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?

Avatar
Discard
Avatar
Tanveer Singh
Author 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.

Avatar
Discard
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 !

Avatar
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.

Avatar
Discard
Tanveer Singh
Author

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

Avatar
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

Avatar
Discard
Related Posts Replies Views Activity
RML report word in blocktable too long
rml report
Avatar
0
Apr 17
3005
rml Problem-except_orm: ('', (<type 'exceptions.AssertionError'>, AssertionError(), <traceback object at 0x242C6788>))..any help ?
rml report
Avatar
Avatar
1
Apr 17
4338
printing sequence in rml surprises me
rml report
Avatar
Avatar
2
Nov 15
4754
Printing html field in rml report with its formatting
rml report
Avatar
0
Mar 15
4529
Cant export to RML using OpenOffice
rml report
Avatar
Avatar
1
Mar 15
5040