Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Бухоблік
Склад
PoS
Проект
MRP

All apps

All Posts Люди Значки

Мітки (View all)

odoo accounting v14 pos v15

Про цей форум

Допомога

How to change table/column at pdf reports?

studio

2 Відповіді

3737 Переглядів

kroetz@mowy.at

Hi,
we want to change the width of the product name/descripton column a little bit, as this looks not really good right now. Do you have any advice where i can change this? Tried it with studio and didn't find anything.

v18 online

thank you!

kroetz@mowy.at

Автор

Dear Emad,

whatever i try there doesn't effect the layout. looking forward to your assist.

here is my source html code of the report:

<data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[11]" meta-class="oe_structure"/>
    <xpath position="after" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[10]">
      <div class="oe_structure">
        <br/>
      </div>
    </xpath>
  </data>
  <data>
    <xpath position="inside" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div" meta-class="oe_structure">
      <span class="o_small-fs">
        <strong>
          </strong>
      </span>
      <strong>
        <font style="color: rgb(189, 148, 0);">
          </font>
        <font style="color: rgb(0, 0, 0);">
          <span class="o_small-fs">Kunden-Nr:</span>
        </font>
        <font style="color: rgb(189, 148, 0);">
        </font>
      </strong>
      <span class="o_small-fs">
        <strong>
        </strong>
      </span>
      <span t-field="doc.partner_id.id" class="o_small-fs"/>
    </xpath>
  </data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//t[@t-set='layout_document_title']/span[2]" meta-t-elif="doc.state in ['draft','sent']"/>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//t[@t-set='layout_document_title']/span[2]" meta-t-else=""/>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//t[@t-set='layout_document_title']/span" meta-t-if="is_proforma"/>
    <xpath position="before" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//t[@t-set='layout_document_title']/span[@t-field='doc.name']" meta-t-field="doc.name">
      <span t-if="is_proforma">
        <span class="o_small-fs">Pro-Forma Rechnung # </span>
      </span>
      <span t-elif="doc.state in ['draft','sent']">
        <span class="o_small-fs">Angebot # </span>
      </span>
      <span t-else="">
        <span class="o_small-fs">Auftrag # </span>
      </span>
    </xpath>
  </data>
  <data>
    <xpath position="attributes" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//t[@t-set='layout_document_title']//span[@t-field='doc.name']" meta-t-field="doc.name">
      <attribute name="class">o_small-fs</attribute>
    </xpath>
  </data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//div[@name='informations_reference']/strong"/>
    <xpath position="before" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//div[@name='informations_reference']/div[@t-field='doc.client_order_ref']" meta-t-field="doc.client_order_ref">
      <strong>
        <span class="o_small-fs">Referenz</span>
      </strong>
    </xpath>
  </data>
  <data>
    <xpath position="attributes" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[@id='informations']/div[@name='informations_reference']/div[@t-field='doc.client_order_ref']" meta-t-field="doc.client_order_ref">
      <attribute name="class">o_small-fs</attribute>
    </xpath>
  </data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//div[@name='informations_date']/strong" meta-t-if="is_proforma"/>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//div[@name='informations_date']/strong[2]" meta-t-else=""/>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//div[@name='informations_date']/strong" meta-t-elif="doc.state in ['draft', 'sent']"/>
    <xpath position="before" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//div[@name='informations_date']/div[@t-field='doc.date_order']" meta-t-field="doc.date_order" meta-t-options="{&quot;widget&quot;: &quot;date&quot;}">
      <strong t-if="is_proforma">
        <span class="o_small-fs">Auftragsdatum</span>
      </strong>
      <strong t-elif="doc.state in ['draft', 'sent']">
        <span class="o_small-fs">Auftragsdatum</span>
      </strong>
      <strong t-else="">
        <span class="o_small-fs">Auftragsdatum</span>
      </strong>
    </xpath>
  </data>
  <data>
    <xpath position="attributes" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[@id='informations']/div[@name='informations_date']/div[@t-field='doc.date_order']" meta-t-field="doc.date_order" meta-t-options="{&quot;widget&quot;: &quot;date&quot;}">
      <attribute name="class">o_small-fs</attribute>
    </xpath>
  </data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//div[@name='expiration_date']/strong"/>
    <xpath position="before" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//div[@name='expiration_date']/div[@t-field='doc.validity_date']" meta-t-field="doc.validity_date">
      <strong>
        <span class="o_small-fs">Gültig bis</span>
      </strong>
    </xpath>
  </data>
  <data>
    <xpath position="attributes" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[@id='informations']/div[@name='expiration_date']/div[@t-field='doc.validity_date']" meta-t-field="doc.validity_date">
      <attribute name="class">o_small-fs</attribute>
    </xpath>
  </data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[@id='informations']/div[4]/strong"/>
    <xpath position="before" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[@id='informations']/div[4]/div" meta-t-if="doc.incoterm_location">
      <strong>
        <span class="o_small-fs">Incoterm</span>
      </strong>
    </xpath>
  </data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[@id='informations']/div[4]/div/br"/>
    <xpath position="after" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[@id='informations']/div[4]/div/span[@t-field='doc.incoterm.code']" meta-t-field="doc.incoterm.code">
      <span class="o_small-fs">
        <br/>
      </span>
    </xpath>
  </data>
  <data>
    <xpath position="attributes" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//span[@t-field='doc.incoterm.code']" meta-t-field="doc.incoterm.code">
      <attribute name="class">o_small-fs</attribute>
    </xpath>
  </data>
  <data>
    <xpath position="attributes" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//span[@t-field='doc.incoterm_location']" meta-t-field="doc.incoterm_location">
      <attribute name="class">o_small-fs</attribute>
    </xpath>
  </data>
  <data>
    <xpath position="attributes" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[@id='informations']/div[4]/div[@t-field='doc.incoterm.code']" meta-t-else="" meta-t-field="doc.incoterm.code">
      <attribute name="class">o_small-fs</attribute>
    </xpath>
  </data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[@id='informations']/div[5]/strong"/>
    <xpath position="before" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[@id='informations']/div[5]/div[@t-field='doc.user_id']" meta-t-field="doc.user_id">
      <strong>
        <span class="o_small-fs">Ihr Kontakt</span>
      </strong>
    </xpath>
  </data>
  <data>
    <xpath position="attributes" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//div[@t-field='doc.user_id']" meta-t-field="doc.user_id">
      <attribute name="class">o_small-fs</attribute>
    </xpath>
  </data>
  <data>
    <xpath position="inside" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[3]" meta-class="oe_structure">
      <br/>
    </xpath>
  </data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/table/thead/tr/th[@name='th_quantity']" meta-name="th_quantity" meta-class="text-end text-nowrap"/>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/table/thead/tr/th[@name='th_priceunit']" meta-name="th_priceunit" meta-class="text-end text-nowrap"/>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/table/thead/tr/th[@name='th_description']" meta-name="th_description" meta-class="text-start"/>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/table/thead/tr/th[@name='th_taxes']" meta-name="th_taxes" meta-class="text-end"/>
    <xpath position="before" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/table/thead/tr/th[@name='th_discount']" meta-name="th_discount" meta-t-if="display_discount" meta-class="text-end">
      <th name="th_description" class="text-start">
        <span class="o_small-fs">Produkt</span>
      </th>
      <th>
        <p>
          <span class="o_small-fs">HS-Code</span>
        </p>
      </th>
      <th>
        <p>
          <span class="o_small-fs">CO</span>
        </p>
      </th>
      <th name="th_quantity" class="text-end text-nowrap">
        <span class="o_small-fs">Menge</span>
      </th>
      <th name="th_priceunit" class="text-end text-nowrap">
        <span class="o_small-fs">Preis</span>
      </th>
    </xpath>
    <xpath position="after" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/table/thead/tr/th[@name='th_discount']" meta-name="th_discount" meta-t-if="display_discount" meta-class="text-end">
      <th name="th_taxes" class="text-end">
        <span class="o_small-fs">Steuer</span>
      </th>
    </xpath>
  </data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//th[@name='th_discount']/span"/>
    <xpath position="inside" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//th[@name='th_discount']" meta-name="th_discount" meta-t-if="display_discount" meta-class="text-end">
      <span class="o_small-fs"> Rabatt</span>
    </xpath>
  </data>
  <data>
    <xpath position="attributes" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/table/thead/tr/th[@name='th_subtotal']/span">
      <attribute name="class">o_small-fs</attribute>
    </xpath>
  </data>
  <data>
    <xpath position="after" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/table/tbody/t[2]/tr/t/td[@name='td_name']" meta-name="td_name">
      <td>
        <p>
          <span t-field="line.product_id.hs_code"/>
          <br/>
        </p>
      </td>
      <td>
        <p>
          <span t-field="line.product_id.country_of_origin.code"/>
          <br/>
        </p>
      </td>
    </xpath>
    <xpath position="after" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/table/tbody/t[2]/tr/t/td[@name='td_priceunit']" meta-name="td_priceunit" meta-class="text-end text-nowrap">
      <td t-if="display_discount" class="text-end">
        <o-diff-hole for="150"/>
      </td>
    </xpath>
    <xpath expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/table/tbody/t[2]/tr/t//o-diff-hole[@for='150']" position="replace">
      <xpath position="move" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//span[@t-field='line.discount']" meta-t-field="line.discount"/>
    </xpath>
  </data>
  <data>
    <xpath position="attributes" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//td[@name='td_section_line']" meta-name="td_section_line" meta-colspan="99">
      <attribute name="colspan">101</attribute>
    </xpath>
  </data>
  <data>
    <xpath position="attributes" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//td[@name='td_note_line']" meta-name="td_note_line" meta-colspan="99">
      <attribute name="colspan">101</attribute>
    </xpath>
  </data>
  <data>
    <xpath position="attributes" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//td[@name='td_section_subtotal']" meta-name="td_section_subtotal" meta-colspan="99">
      <attribute name="colspan">101</attribute>
    </xpath>
  </data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[10]/p[@id='fiscal_position_remark']" meta-t-if="doc.fiscal_position_id and not is_html_empty(doc.fiscal_position_id.sudo().note)" meta-id="fiscal_position_remark"/>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[10]/span[@name='order_note']" meta-t-field="doc.note" meta-t-attf-style="#{'text-align:justify;text-justify:inter-word;' if doc.company_id.terms_type != 'html' else ''}" meta-name="order_note"/>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[10]/p[2]" meta-t-if="not is_html_empty(doc.payment_term_id.note)"/>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[10]/div" meta-class="oe_structure"/>
    <xpath position="after" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[10]/p[@id='carrier_description']" meta-t-if="doc.carrier_id.carrier_description" meta-id="carrier_description">
      <div t-out="doc.carrier_id.carrier_description" class="o_small-fs"/>
      <p/>
      <span t-field="doc.note" t-attf-style="#{'text-align:justify;text-justify:inter-word;' if doc.company_id.terms_type != 'html' else ''}" name="order_note" class="o_small-fs"/>
      <p t-if="not is_html_empty(doc.payment_term_id.note)">
        <span t-field="doc.payment_term_id.note" class="o_small-fs">The payment should also be transmitted with love</span>
      </p>
      <div class="oe_structure"/>
      <p t-if="doc.fiscal_position_id and not is_html_empty(doc.fiscal_position_id.sudo().note)" id="fiscal_position_remark">
        <strong>
          <span class="o_small-fs">Fiscal Position Remark:
        </span>
        </strong>
        <span class="o_small-fs">
                    </span>
        <span t-field="doc.fiscal_position_id.sudo().note" class="o_small-fs">No further requirements for this payment</span>
      </p>
    </xpath>
  </data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//p[@id='carrier_description']/strong"/>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//p[@id='carrier_description']/div" meta-t-out="doc.carrier_id.carrier_description"/>
    <xpath position="inside" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']//p[@id='carrier_description']" meta-t-if="doc.carrier_id.carrier_description" meta-id="carrier_description">
      <strong>
        <span class="o_small-fs">Versandinformation</span>
      </strong>
    </xpath>
  </data>
  <data>
    <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/table/tbody/t[2]/tr/t/td[7]" meta-t-if="display_discount" meta-class="text-end"/>
  </data>
</data>

Emad Akram

can you share with me the name of the report please

kroetz@mowy.at

Автор

it's the sale.report_saleorder_raw

Emad Akram

I belive that this report is customized and these are customiozed fields

Try to add the colspan attribute here is the usage of it colspan="number"

for example

Emad Akram

will become

=======================================
and

will become

kroetz@mowy.at

Автор

@Emad

not really a good result...

we need the product + product descripton to be bigger

Emad Akram

you will have to select the report => report_saleorder_document (sale.report_saleorder_document)
after that go to line 71 and edit the <th name="th_description" class="text-start">Description</th>
add the column size to the class you want try to test col-4 , col-6 , col-8 and see what works fine for you

it should look like this => <th name="th_description" class="text-start col-8">Description</th>

after that add the same class to the line 92
this is the line
<td name="td_name">Bacon Burger</td>

make it look like this by adding the class class="col-8"

<td name="td_name" class="col-8">Bacon Burger</td>

Emad Akram

Hello,

You can change the width using the studio by going to reports then selecting the wanted report then edit the source code by pressing the "</> EDIT SOURCES" button.

After that you can manipulate the HTML to print the report the way you like for example add a colspan attribute.

You can share with us the exact report for more help.

I hope this helps

kroetz@mowy.at

Автор

it's the sale.report_saleorder_raw

kroetz@mowy.at

Автор

nothing changed with this codes at line 72 + 92

Emad Akram

you have to save it to for it to work

kroetz@mowy.at

Автор

I did - nothing changed

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Реєстрація

Related Posts	Відповіді	Переглядів
debit and credit in currency studio	1 лист. 25	2166
Menu's with different default filter Вирішено studio	1 лип. 25	2247
Digest mails - any good resources for Studio Вирішено studio	2 бер. 25	2382
Payment terms format change studio	0 лют. 25	1968
V18 of odoo, How to add a computed field in a stock report? Example: Total weight of my available product. studio	0 лют. 25	2462

Це запитання позначене

Enjoying the discussion? Don't just read, join in!