Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

Add image/picture in SXW report

By
Selverine
on 8/24/13, 1:15 PM 3,408 views

Hi everybody,

I would like to add a picture in a SXW report. I know that is possible in rml, but how is possible in SXW?

Thank you a lot!

Selverine

3
Jaydeep Barot (jar)
On 7/3/14, 4:58 AM

Try this: It's working for to add image in Report using by sxw file.

[[ o.product_id.image and setTag('para','image',{'width':'30','height':'30'}) ]] [[ o.product_id.image ]]

I am waiting your reply it's working fine.
Thanks.

 

0

Luke Branch

--Luke Branch--
1531
| 6 7 8
Mui Wo, Lantau, Hong Kong
--Luke Branch--

...

Luke Branch
On 7/4/14, 8:17 AM

If you are looking to add a product image to a printed report (ie. PDF or HTML) sales order, purchase order, invoice, or any other report with product order lines I believe I have figured out a solution thanks to Fabrice Henrion's post here: https://www.odoo.com/forum/Help-1/question/Is-there-any-way-to-preview-WebKit-report-layout-while-coding-maybe-WYSIWYG-Editor-52307.

Simply follow Fabrice's instructions as follows (preferably use latest v8 master branch version):

  1. First you have to know that the new QWeb engine allows to output PDF or HTML. It is only when the output is HTML that it can be modified in a WYSIWYG fashion.
  2. Let's assume the Sales module is installed on a fresh Odoo instance. By default, the output of a quotation document is PDF, you can test that by printing a quotation. We want to change this.
  3. Make sure your user has the technical feature checkbox checked. Then go to Settings > Technical > Reports > Reports, then search "sale.order" and enter the record.
  4. Edit the Report Type from PDF to HTML, then Save.
  5. Go back to the Sales app and print a quotation.
  6. A popup appear (or your popup-blocker will notify you). You will see the quotation in that popup and a black bar at the top with the Edit button. You need to make sure you have the access right to edit this so I recommend you do this test as an admin.
  7. From there, it's pretty straightforward. You edit whatever you want. You have to realize that there are 2 types of edition on a record like this: editing this particular record, or editing the quotation template which will have an impact on all records. For example, if you edit a header, it will be a template edition.

If you want to add an image to an order line simply edit the HTML in the HTML editor found in the top navigation menu under Customize >> HTML Editor and find the place in the HTML/QWeb template that you would like to edit. I simply added an extra set of <th></th> tags as follows for a order line header (in the appropriate section of html/qweb that is):

<th class="text-left"><strong>Picture</strong></th>

and then added the following line for the sales order line product picture column:

                                <td class="text-center">
                                   <span t-field="line.product_id.image_small" t-field-options="{&quot;widget&quot;: &quot;image&quot;, &quot;class&quot;: &quot;img-rounded&quot;}"/>
                                </td>

The contents of the <span> tag pull the product image into the sales order line in the column that you want and when you save your html your report will display the appropriate product picture in 64px x 64px.

There may be a better way to do this and I welcome any comments on how this process might be improved.

0
joseph d'souza
On 8/24/13, 2:36 PM

Try this :

            <image x="1.3cm" y="27.7cm" height="40.0" >[[ image.name or removeParentNode('image') ]]</image>

Are they some document about the SXW ? TO konw the different between SXW and RML?

Selverine
on 8/28/13, 2:23 PM

Read the developer book of OpenERP. This book is available on OpenERP DOCUMENTATION section(e-book).

Koffi KPONOUGLO
on 9/14/13, 5:25 PM

Hi Joseph, I'm also interested in this. Are you aware of any method to put images on sales order and purchase order lines in RML for v8/master?

Luke Branch
on 7/3/14, 5:28 AM
0
Selverine
On 8/24/13, 3:28 PM

Hi Joseph d'souza,

Thank you for your help.

It works only when i use it in rml code, but with my report in sxw it didn't works. Are they some documents about the SXW ? To know the difference between SXW and RML? Or to put some RML code directly in the SXW code?

My report print

" <image x="1.3cm" y="27.7cm" height="40.0" >="" ivborw0kgoaaansu.....="" and="" not="" print="" a="" picture<="" p="">

Have you an idea?

Thank you!

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 8/24/13, 1:15 PM
Seen: 3408 times
Last updated: 3/16/15, 8:10 AM