Rocker Reporting Application

for Odoo 12.0 / Odoo 13.0 / Odoo 14.0

Collect data to single Excel from various data sources, Use Excel templates to present business graphs. Combine data with Excel Power Pivot. Get data from Odoo & external PostgreSQL, SQLServer, MySQL, MariaDB, ODBC or Oracle databases.

News/Notes:

• 15.2.2021

  At the moment we have a problem starting Excel if Odoo runs as a service.
  Everything works well if you start Odoo from command prompt. See install guide in docs folder.

  If someone knows the solution to: excel = win32.gencache.EnsureDispatch('Excel.Application') causing (-2147023584, 'A specified logon session does not exist. It may already have been terminated.', None, None) error, pls email.

  Openpyxl version https://apps.odoo.com/apps/modules/14.0/rocker_app_v3/ does not have a problem but this one supports all Excel 2016 features including Power Pivot

  Author contact: antti.rocker.karki@outlook.com

Requirements:

1. Odoo 12 or Odoo 13 or Odoo 14 installed on Windows platform
2. Excel installed on server
3. Datasource drivers (PostgreSQL, SQLServer, Oracle, MySQL, MariaDB etc.) installed on server based on your needs

Examples:

1. Powerpoints: Powerpoint table slide
   
   


2. Powerpoints: Powerpoint Column Chart slide
   
   


3. Powerpoints: Powerpoint Pie Chart slide
   
   


4. Powerpoints: Powerpoint Collection
   
   


5. Rocker Excel example: Data from single datasource
   
   


6. Rocker Excel example: Collection reports, data from many datasources
   
   

Guides:

1. Install guide

Demos:

1. View Basic demo
   
   


2. PowerPoints demo
   
   


3. Get data from SQLServer demo
   
   


4. Collection Reports demo, get data from many data sources
   
   


5. Access rights demo
   
   


6. Hyperlinks demo
   
   


7. Scheduler demo