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

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

How to change table/column at pdf reports?

studio

2 Vastaukset

3735 Näkymät

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

Tekijä

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

Tekijä

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

Tekijä

@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

Tekijä

it's the sale.report_saleorder_raw

kroetz@mowy.at

Tekijä

nothing changed with this codes at line 72 + 92

Emad Akram

you have to save it to for it to work

kroetz@mowy.at

Tekijä

I did - nothing changed

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
debit and credit in currency studio	1 marrask. 25	2166
Menu's with different default filter Ratkaistu studio	1 heinäk. 25	2247
Digest mails - any good resources for Studio Ratkaistu studio	2 maalisk. 25	2382
Payment terms format change studio	0 helmik. 25	1968
V18 of odoo, How to add a computed field in a stock report? Example: Total weight of my available product. studio	0 helmik. 25	2461

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!