Ir al contenido
Se marcó esta pregunta
rmlreport
3 Respuestas
9510 Vistas
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
Descartar
Avatar
Tanveer Singh
Autor Mejor respuesta

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
Descartar
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
Mejor respuesta

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
Descartar
Tanveer Singh
Autor

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

Avatar
JohnWang
Mejor respuesta

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
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
RML report word in blocktable too long
rml report
Avatar
0
abr 17
3982
rml Problem-except_orm: ('', (<type 'exceptions.AssertionError'>, AssertionError(), <traceback object at 0x242C6788>))..any help ?
rml report
Avatar
Avatar
1
abr 17
5187
printing sequence in rml surprises me
rml report
Avatar
Avatar
2
nov 15
5736
Printing html field in rml report with its formatting
rml report
Avatar
0
mar 15
5481
Cant export to RML using OpenOffice
rml report
Avatar
Avatar
1
mar 15
6056