India

ZestyBeanz Technologies Pvt Ltd 4th Floor, Nila, Technopark Thiruvananthapuram,
India – 695581
Phone: +91 471 4063254
Fax : +91 471 2700171

   .

ZestyBeanz Technologies Pvt Ltd
61/3236, Manikkath Cross Road
Ravipuram, Kochi, India - 682016
Phone: +91 484 4063254

  UAE

Zesty Labs
Office # 2003, Millennium Plaza Building
Sheikh Zayed Rd, Dubai, UAE
Phone: +971 4333 2222​
Mobile: +971-52-7553466

  Germany​

ZestyBeanz Technologies GmbH
Reuterstraße 1
90408 Nürnberg
Fon: +49 911 4801 444
Fax: +49 911 4801 445

Home » Blogs » Prajul P T's blog

Advanced Printscreen for Odoo 7 and Odoo 8(Analytic Report Printing)

Contact Form


Prajul P T's picture

Advanced Printscreen for Odoo 7 and Odoo 8(Analytic Report Printing)

January 16, 2015 By Prajul P T

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.

AttachmentSize
web_printscreen_zb_24_mar_v7.zip18.16 KB
web_printscreen_zb_24_mar_v8.zip18.69 KB

Prajul P T's picture

Hi,     I have solved the

Submitted by Prajul P T on Fri, 10/25/2013 - 05:38.

Hi,

    I have solved the issue. Please check now...

Thanks for reporting this issue...

Kenny's picture

Client error When I export

Submitted by Kenny (not verified) on Wed, 10/16/2013 - 15:56.

Client error

When I export pdf or excel from Reporting-->Purchase-->Purchase Analysis, I got a client error:

Error: '99%' is not a correct float

Prajul P T's picture

Hi,     Please check now....

Submitted by Prajul P T on Fri, 10/18/2013 - 11:14.

Hi,

    Please check now....

Kenny's picture

OK. It works well. Thank you

Submitted by Kenny (not verified) on Sat, 10/19/2013 - 03:57.

OK. It works well.

Thank you very much.

Anonymous's picture

Hie, I have installed the

Submitted by Anonymous (not verified) on Mon, 10/14/2013 - 04:59.

Hie, I have installed the module as well as python-xlwt in openerp-7.0. But I am unable to view the buttons although the addons has been properly installed. Please help

ciji's picture

Thanks! Good work

Submitted by ciji (not verified) on Sat, 09/28/2013 - 07:44.

Thanks! Good work

Anonymous's picture

Can we have a similar module

Submitted by Anonymous (not verified) on Fri, 09/27/2013 - 08:43.

Can we have a similar module to work with version 6.1? I installed the same module with 6.1 but there is no such "button to export to pdf". please help i need this on urgent basis.

Andres Calle's picture

Great module! I like the very

Submitted by Andres Calle (not verified) on Sun, 09/22/2013 - 22:54.

Great module! I like the very easy way to use this module, great contribution to all OpenERP users. One suggestion, include some security filter to allow exporting only to specific user groups, that will be needed in order to use in a medium size company.

David's picture

Thanks for sharing excelent

Submitted by David (not verified) on Mon, 09/09/2013 - 17:21.

Thanks for sharing excelent module.
I've installed the old version (http://www.zbeanztech.com/blog/printscreen-openerp-7).
after I updated this version. I can not export the report. For example:
I've Export to pdf or Export to Excel next to the number of records in tree view. But I click to it, nothing happened.
Please help me!

Bryan's picture

Hello, We resolve the problem

Submitted by Bryan (not verified) on Tue, 09/10/2013 - 16:57.

Hello,

We resolve the problem of the next form:

In the line 75 replace
cellvalue = float(cellvalue)

by the next:

try:
cellvalue = float(cellvalue)
except:
cellvalue = cellvalue