Skip to Content
Dette spørgsmål er blevet anmeldt
rmlreport
3 Besvarelser
9449 Visninger
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
Kassér
Avatar
Tanveer Singh
Forfatter Bedste svar

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
Kassér
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
Bedste svar

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
Kassér
Tanveer Singh
Forfatter

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

Avatar
JohnWang
Bedste svar

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
Kassér
Related Posts Besvarelser Visninger Aktivitet
RML report word in blocktable too long
rml report
Avatar
0
apr. 17
3932
rml Problem-except_orm: ('', (<type 'exceptions.AssertionError'>, AssertionError(), <traceback object at 0x242C6788>))..any help ?
rml report
Avatar
Avatar
1
apr. 17
5155
printing sequence in rml surprises me
rml report
Avatar
Avatar
2
nov. 15
5684
Printing html field in rml report with its formatting
rml report
Avatar
0
mar. 15
5433
Cant export to RML using OpenOffice
rml report
Avatar
Avatar
1
mar. 15
5995