跳至内容
此问题已终结
rmlreportsxwlandscapeboundary
2 回复
9974 查看
形象
Aitzol

I am trying to create a new SXW RML report in landscape format. I have been able to convert the RML to A4 landscape mode but I have some issues with a tables and page breaks.

I'd like the report to display 4 tables, all of them in one page. This is the draft of the report I am designing:

Image: www.solid-rock-it.com/web-solid-rock/blog/images/OpenERP/Captura.PNG

I would like the Table3 and Table4 to be rendered lower than in the draft. But the problem is that if I add a new line before the Table3 or Table4, the RML conversion creates a new page break, and the tables are rendered in a second page.

I think the problem has something to do with the frame size and its boundaries. As it can be seen in the previous image in which the boundaries are displayed, the bondaries are configured as if the page was in portrait mode instead of landscape. How can I change the boundaries to adapt them to landscape mode?

RML file:

<?xml version="1.0"?>
<document filename="test.pdf">
  <template pageSize="(842.0,595.0)" title="Test" author="Martin Simon" showBoundary="1" allowSplitting="20">
    <pageTemplate id="first">
      <frame id="first" x1="57.0" y1="57.0" width="728" height="481"/>
    </pageTemplate>
  </template>

Thanks,

形象
丢弃
Keyur

Hi Aitzol, can you please tell me which OpenERP version you are using? Make sure you are upto latest updates. Thanks

Aitzol
编写者

I am using openerp 6.1.1. Fortunately, I have been able to find a solution to the problem

形象
Keyur
最佳答案

Hi Aitzol, tables are not displayed properly because the report is A4 size in portrait. You just need to convert portrait document in landscape mode then it will be in proper order. First open your sxw file in there go to Format->Page menu there you can see Orientation:Landscape.

image description

You can also set page size from rml. Generally template pagesize is (842,595) for landscape report. You can also change in frame tag as per your need.

  <template pageSize="(842.0,595.0)" title="Test" author="Martin Simon" allowSplitting="20">
    <pageTemplate id="first">
      <frame id="first" x1="35.0" y1="35.0" width="772" height="525"/>
       <header>
                //Your Company header
      </header>      
    </pageTemplate>
  </template>
形象
丢弃
Aitzol
编写者

Thanks Keyur, The SXW report is already in landscape mode and the page layout in the PDF is a A4 in landscape format, as my previous image shows (notice the right margin). The problem is that the page boundaries remain as if it was in portrait mode.

Aitzol
编写者

The strangest thing is that the template's and frame's sizes are already configured for landscape mode. The boundaries however, remain to be in portrait mode. This is the RML:

<?xml version="1.0"?> <document filename="test.pdf"> <template pageSize="(842.0,595.0)" title="Test" author="Martin Simon" showBoundary="1" allowSplitting="20"> <pageTemplate id="first"> <frame id="first" x1="57.0" y1="57.0" width="728" height="481"/> </pageTemplate> </template>

Image of the PDF, still with wrong boundaries: http://www.solid-rock-it.com/web-solid-rock/blog/images/OpenERP/Captura2.PNG

Keyur

Maybe because you are printing barcode report so that's why the report is not in actual width try to reduce the width of the barcode table then it might help. Thanks

形象
Aitzol
编写者 最佳答案

I finally found the solution to the problem with the page landscape layout. The problem was that although the page was in landscape mode, the page frame remained in portrait mode.

I found that all dimensions in the rml were ok and the problem was somewhere else, in the report's python file to be precise:

report_sxw.report_sxw('report.modulename.product.label','mrp.production','addons/modulename/report/product_label.rml',parser=order,header=False)

The problem has been solved by adding "header=False" parameter to the report_sxw method call. It seems that by not adding this parameter, OpenERP modifies the page layout in order to add the header, which is configured to be in portrait mode. This was overwriting the settings for landscape mode in my RML file.

形象
丢弃
Luis Lozano

I have the same problem, I have OpenERP Online, do you know where can I find this file? Thanks

相关帖文 回复 查看 活动
can we change rml file to sxw ?
rml report sxw
形象
形象
形象
2
3月 15
7193
How to repeate column in RML report
rml report sxw
形象
0
3月 15
6390
odt format report in rml reporting
rml report sxw odt
形象
形象
1
3月 15
5435
list index out of rangeparagraph text u'<para></font></para>' caused exception" 已解决
rml openoffice report sxw openerp7
形象
形象
形象
4
8月 15
7197
.sxw to .rml convertion problems can anybody help?
rml reporting report sxw convetrion
形象
形象
形象
2
3月 15
6474