Skip to Content
This question has been flagged
layoutwebkitpreviewwysiwyg
22 Replies
45061 Rodiniai
Portretas
NSC

I consider to play with WebKit Reporting once again. What is really cumbersome with Reporting in general, is layouting. Therefore, the choice of my next reporting engine would depend on the availability of a graphical layout editor. It is not important, if all the report can be built with it, but for quicker and more comfortable layouting a layout preview is strongly required.

Up to now, I use ReportLab with OpenOffice Report Designer. Report Designer I only use for layout purposes - all the rest I do by directy working with the code, i. e. I build my layout with Report Designer, export it as .rml and push the latter to the directory of my custom report module. I would like to continue with this procedure using WebKit as Reporting Engine. I need not know how to set it up in OpenERP, but if there is any possibility of coding with layout preview.

Portretas
Atmesti
Portretas
Fabrice Henrion (fhe)
Best Answer

Are you aware that the latest version of Odoo comes with a QWeb report engine that allows WYSIWYG edition just like for the CMS website builder? It sounds like this is what you are looking for. Create an Odoo Online account and check it out.

Here is how to test it (you must be on v7-SaaS4 or later so I recommend to try it on Odoo Online):

  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 and the 'website' module installed. 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.
Portretas
Atmesti
Fabien Pinckaers (fp)

For Customize top menu, you can also use the HTML editor directly.

Luke Branch

Hi Fabrice, Thank you, this is exactly what I was looking for and has allowed me to add images to order lines and customise any report easily just using basic HTML/QWeb. This makes customisation extremely easy in v8.

Yenthe Van Ginneken (Mainframe Monkey)

Sadly this does not work in Odoo 8 (Version 9.0 Alpha 1). You will get an internal error, Internal Server Error "The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application."

Infosis SpA

Does'nt work, the edit button comes up disable, it's there some workaround

Pascal de Clarens

Hi, Your solution seems exactly what i am looking for. Unfortunatly, after changind the pdf to html, when I print a quotation I get this error message: Uncaught SyntaxError: Unexpected end of input https://adret.odoo.com/web?#id=4&view_type=form&model=sale.order&menu_id=304&action=378:0 What did I miss? Thanks for your help

XaRz

Thanks for this. I was began to think that odoo has released de 8 version in early dev stage. This is a great great improvement. Thank you for taking your time to explain this. Regards PS: As GrupoCiTEC has mentioned you need to have the Web Designer module to be able to edit the html. Perhaps editing your answer would be great.

E.R. Spada

Hello Fabrice, I just pulled the latest v8 and the instructions that you provided do not work, nothing happens and nothing is noted in the log, I can get to a report by using the url e.g.http://localhost:8069/report/html/account.report_invoice/1 but not from the print menu? Is this still in development? TX ER

E.R. Spada

Sorry, I could see the pop-up blocker on saas, but was not notified on my local browser.... ER

Randy Risser

This does not seem to work anymore in v12 up. Is there a new way to go about this?

Portretas
GrupoCITEC
Best Answer

Hi, just to add that you need to have the 'website' module installed in order to see the EDIT button in the rendered html report

Portretas
Atmesti
XaRz

ty! Great tip!

Damodar D.

Almost 5 hours lost before found this mandatory tip, thanks!

Portretas
Stefan Joachim
Best Answer

Hi,

I tried to change the layout (move boxes and delete lines), but I'm only able to delete text.
I use the odoo "Version 8.0" installed while using the script:
https://github.com/aschenkels-ictstudio/openerp-install-scripts/blob/master/odoo-v8/ubuntu-14-04/odoo_install.sh

Example, I try to move the customer address from right page site to the left. But I'm not able to do that. I see the "edit" button, and I see in the pull down menu "customize content".

My question, How can I change the layout totally free for printing a pdf report, in this case a invoice? Is ther a complete How to for beginners? I'm not a developer :-) But I'm able to edit HTML and CSS.

Thanks a lot for help

Stefan

 

Portretas
Atmesti
Portretas
Annette Schoepgens
Best Answer

HI,

can it be, that this function is not given correctly at the latest Odoo v9 ?

I can change the report print view from PDF  to HTML and open the report. Then it's possible to change some text, but i cannot move/delete/add snippets on this report like website builder.

The left toolbar (from websuite builder) just pop in for a 1/10 second and then pop out. No change to become back the toolbar.

I've seen this on a youtube video and i think thats a great tool to edit the reports.

Thank you

Marco

Portretas
Atmesti
Portretas
Tankgirl
Best Answer

As we are discussing the layout of the reports here, I want to ask my question here.
Is there a way (a WYSIWYG way) to edit external_layout_footer and external_layout_header?

I have tried editing it inside a report (with the way explained here) , but when I save it, the header becomes totally different. I don't think this is the right way to edit this.

I know how to edit the header and footer in code mode by the way.

Portretas
Atmesti
Portretas
Thomas Fossoul
Best Answer

Hi,

Do you know if this is possible to edit localy the document when you are on the html editor then save it as pdf ?  

So i need to have the normal template of the sale order (for instance) then i would like edit it just before sending it to the customer (or save it as pdf) without edit the template used each time a generate a sale order...

 

 

 

Portretas
Atmesti
Portretas
NSC
Autorius Best Answer

Fabrice, I have just tried what you told, popup opens, but without any toolbar or edit button... What am I doing wrong? I am logged in as admin user and report to print is set to html...

Portretas
Atmesti
XaRz

You need to install the web designer module! :)

Portretas
Torvald Baade Bringsvor
Best Answer

Has there been some change here in the latest 8.0rc1 branch? The edit button comes up disabled here...

Portretas
Atmesti
Portretas
NSC
Autorius Best Answer

Thank you very much, Fabrice! This helps me very much to estimate how to proceed!

At the moment, I have a custom module with 3 different customized rml report templates inside. As I use OpenERP/Odoo Community Version and have some custom modules which also change data models (res.partner where I added some additional fields to), I will need a bit of time to upgrade to v8, because data migration will not be too easy-going. But in the meantime, I could try to convert my .rml templates to HTML code what I think to be not too easy-going, too, but I suppose or hope it will be possible. If not, I have to take the predesigned webkit templates and modify them within v8 to approach my current .rml layout. For that purpose, the information you gave above will be very helpful to me. Maybe I will try like that first. Then I can change to webkit within my v7, install new custom webkit report module designed by the help of v8, copy modified header code where it belongs to (maybe it can also be placed to my custom module - up to now, I have not found out, how to) and my webkit migration should be finished. Whenever I need to change layout, I can do this using v8 till time will have come to change to v8 entirely.

Portretas
Atmesti
Portretas
mohsel
Best Answer

Thank you Fabrice, your guide is clear and very helpful, but how can i modify the html templates ? for more technicals customization like adding an amount_to_text field ?

Portretas
Atmesti
Luke Branch

@mohsel, i've been doing some custom work on the saleorder, invoice, and other documents by adding the customisations to a custom module thanks to the tips from Fabrice on QWeb. Please provide some more information on what exactly you'd like to achieve in regards to customisations and i'd be happy to provide you with whatever information I can to help.

Related Posts Replies Rodiniai Veikla
How do I start using WebKit reports? Solved
layout reporting webkit
Portretas
Portretas
Portretas
2
rugs. 15
17371
Css layout of webkit reports - do DIV margins work?
layout webkit reports
Portretas
0
kov. 15
2845
Document Layout Discrepancy Between PDF and Web Preview (Odoo v17)
configuration invoice layout preview document_page
Portretas
0
rugp. 24
1823
Document Layout customize
layout
Portretas
Portretas
1
saus. 25
2350
v18 Document layout Problem Solved
layout
Portretas
Portretas
2
gruod. 24
3468