Advanced Printscreen for Odoo 7 and Odoo 8(Analytic Report Printing)
Printscreen has been and is an attractive feature of OpenERP. But unfortunately this feature was available for OpenERP 6.1 GTK Client. OpenERP 7 provide an functionality to print the current view in PDF.
You may have already noticed that i have already published a blog named "Printscreen in OpenERP 7 which was a migrated module from web_export_view with few my own functionality added to it. But now we have developed a new module called web_printscreen_zb with some new features that might be helpful to users of OpenERP 7.
The main features of this module are:
- Ability to export view in both PDF as well as in Excel.
- Ability to export analytic views in to PDF and Excel including group totals.
- Hierarchical view of the groups.
The module can be installed as a normal OpenERP module. The only python dependency that is need for the module is python-xlwt which is needed to export to xls file. This can be installed using the comment "sudo apt-get install python-xlwt" for Ubuntu. After installing the module, you can see two anchor buttons called "Export to PDF" and "Export to Excel" on the right side of the OpenERP web client as shown in the screenshot below:
These buttons will only appear if the active view is a tree view. This button wont be visible in any of the other view types. When the button "Export to PDF" is clicked, the report will be exported to PDF or if "Export to Excel", the report will be printed in "Excel". The heading and the totals will be printed in Bold. A sample screenshot of the excel and PDF report is shown below:
The module also allows to print analytic reports in to CSV of excel. The screenshot below shows an analytic view:
You can also see the "Export to Excel" and "Export to PDF" in the top right side of the view. If you click the button "Export to Excel", it will be exported to excel else if "Export to PDF", it will be exported to "PDF". A sample report is shown below:
A video showing the functionality of the module is shown below:
The module is attached with the blog. Module is also shared at https://github.com/zbeanz/openerp-7-web-addons. Module can also be downloaded from launchpad bzr branch lp:~r-launchpadzbeanz/zbeanz/addons.
Module is also available in Odoo 8. Module is attached with the blog.
| Attachment | Size |
|---|---|
| web_printscreen_zb_24_mar_v7.zip | 18.16 KB |
| web_printscreen_zb_24_mar_v8.zip | 18.69 KB |
Hi, This module is
Hi,
This module is developed for OpenERP 7. To work on OpenERP 8, we need to migrate this module. Migration is in process and not yet complete. We will post the migrated module in coming days in this blog or in our lp branch. I will inform you when the migration is complete.
Hello Prajul, I'm very
Hello Prajul, I'm very interested by the module upgrade, I could make some modifications at the code to install the module in Odoo 8, but when I push on "PDF" or "Excel" nothing happens..
It would be Awesome to have this functionality on Odoo 8.
Thanks!
Hi Prajul, It is super useful
Hi Prajul,
It is super useful and great module! Nice Job!
Just found a small bug, when I goes to Location->Products by Location, in that Product List, the report won't work. There is no error showing as well.
You may want to check this?
Hi, We have already
Hi,
We have already fixed this bug. Please try with the latest module. The module is attached with the blog. If the problem persist, please get back.
Hi the latest module in the
Hi the latest module in the attachment is the same as yesterday, right? It still has the same problem.
Hi, I cannot reproduce
Hi,
I cannot reproduce the error from my side. I tested the report from Warehouse > Configuration > Location. Selected one record. In More dropdown, there is a item called "Product by Location". Which opens up a wizard where i selected "Analyze Current Inventory". This opens up a list of product and its stock levels. The report is printing from here also. Please give me the steps you followed so that i can reproduce the error on my side.
It works in another
It works in another server...
I will check myself. Thanks!
Ok that might be the problem.
Ok that might be the problem. I am using the latest OpenERP 7 server.
I want to create a view to
I want to create a view to display balance sheet , P & L and other accounts as per the user selects.
I am using openerp 7.0
It is already there, but what I want is, we can print above reports(financial reports in openerp) HERE
=> I want to disply what is being printed in the reports...!
=> Meaning to say is I want all the calculations field I get from different tables into each one of the accounts like Profit & loss , balance sheet , etc.
=> How is it possible?
=> Do i need to create a template or I have to go through creating the views ? like those already in financial reports?
Your steps are correct and
Your steps are correct and the report just does not print on my server
Are you using the web_printscreen_zb_20_may_2014.zip?