Report in Odoo 11

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

Report in Odoo 11

5 Replies

24465 Views

reporting odoo odoo11

Ismail tlemcani

Hey everyone,

I've a custom module for Odoo 10. I'm trying to upgraded it to Odoo 11.

I face a problem in a qweb report that should appear while clicking on a button. It works on Odoo 10 but not on Odoo 11.

Here is the error I'm facing :

Error:

Odoo Server Error

Traceback (most recent call last):

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 648, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 309, in _handle_exception

raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\tools\pycompat.py", line 86, in reraise

raise value

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 685, in dispatch

result = self._call_function(**self.params)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 341, in _call_function

return checked_call(self.db, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\service\model.py", line 97, in wrapper

return f(dbname, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 334, in checked_call

result = self.endpoint(*a, **kw)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 929, in __call__

return self.method(*args, **kw)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 514, in response_wrap

response = f(*args, **kw)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\web\controllers\main.py", line 920, in call_button

action = self._call_kw(model, method, args, {})

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\web\controllers\main.py", line 908, in _call_kw

return call_kw(request.env[model], method, args, kwargs)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\api.py", line 689, in call_kw

return call_kw_multi(method, model, args, kwargs)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\api.py", line 680, in call_kw_multi

result = method(recs, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\oemaintenance\models\oem_equipment_maintenance.py", line 831, in print_maintenance_task

return self.env['report'].get_action(self, 'oemaintenance.oemaintenance_report_task_template')

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\api.py", line 760, in __getitem__

return self.registry[model_name]._browse((), self)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\modules\registry.py", line 177, in __getitem__

return self.models[model_name]

KeyError: 'report'

Here is the function mentionned in the error :

@api.multi

def print_maintenance_task(self):

return self.env['report'].get_action(self, 'oemaintenance.oemaintenance_report_task_template')

Thanks in advance for your help

Sudhir Arya (ERP Harbor Consulting Services)

Best Answer

Hi Ismail,

In v11, report module has been removed along with report object. For this reason, you are facing this error.
You have to remove the report from depends as it is added / merged in base module.
You can check it here.

You can call your report using report_action method as follow:

self.env.ref('your_report_name').report_action(self, data=data)

Hope this will help you and solve your problem.

Abdullahi

Hello ismael, after a long struggle i finally found the solution, you need to do the following:

@api.multi

FROM THIS

def print_maintenance_task(self):

return self.env['report'].get_action(self, 'oemaintenance.oemaintenance_report_task_template')

TO THIS

@api.multi

def print_maintenance_task(self):

return self.env.ref('report_action_name').report_action(self, data=data, config=False)

Ismail tlemcani

Author

I've tried to add the report module in the manifest file (here is my depend line : 'depends' : ['base','hr','web','report'],) but i got the following error :
You try to install module 'oemaintenance' that depends on module 'report'.
But the latter module is not available in your system.
It seems that the report module does not exist in Odoo 11.

What is the name of the report module in Odoo 11 please ?

Thanks

Sarender Reddy

Hello Ismail tlemcani

You need to remove report string in depends in __manifest__.py file.

Change
'depends' : ['base','hr','web','report'],)
To

'depends' : ['base','hr','web'],)

We are using qweb templates for reports in Odoo 11. This is available in base module only.

Priya

I want to print report by clicking on print button on website using odoo11.

But it shows some error:

File "/home/priya/workspace/ODOO11/odoo-11.0/odoo/http.py", line 829, in dispatch r = self._call_function(**self.params) File "/home/priya/workspace/ODOO11/odoo-11.0/odoo/http.py", line 342, in _call_function return checked_call(self.db, *args, **kwargs) File "/home/priya/workspace/ODOO11/odoo-11.0/odoo/service/model.py", line 97, in wrapper return f(dbname, *args, **kwargs) File "/home/priya/workspace/ODOO11/odoo-11.0/odoo/http.py", line 335, in checked_call result = self.endpoint(*a, **kw) File "/home/priya/workspace/ODOO11/odoo-11.0/odoo/http.py", line 936, in call return self.method(*args, **kw) File "/home/priya/workspace/ODOO11/odoo-11.0/odoo/http.py", line 515, in response_wrap response = f(*args, **kw) File "/home/priya/repo/rp-group/rpg_quotation/controllers/web_page.py", line 1442, in update_quotation res = self.print_quotation_software_report(data, int(quotation_id)) File "/home/priya/repo/rp-group/rpg_quotation/controllers/web_page.py", line 2699, in print_quotation_software_report pdf = request.env.ref('rpg_quotation.rpg_quotation_software_setwise__report').report_action(self, data=data, config=False) File "/home/priya/workspace/ODOO11/odoo-11.0/odoo/addons/base/ir/ir_actions_report.py", line 703, in report_action context = dict(self.env.context, active_ids=active_ids)

UnboundLocalError: local variable 'active_ids' referenced before assignment

My js code:

$(document).on('click', Quotation.elements.print_quotation_software_selector, function() {
 var self = $(this);
 var data = {
   'xpath': null,
   'cmd': 'print_quotation_software_report'
 };
 Quotation.methods.xhr(data, function(r) {
 });

});

My Python code:

def print_quotation_software_report(self,data,quotation_id):
 order_id = quotation_id
 if quotation_id:
   pdf = request.env.ref('rpg_quotation.rpg_quotation_software_setwise__report').report_action(self, data=data, config=False)
   pdfhttpheaders = [('Content-Type', 'application/pdf'), ('Content-Length', len(pdf))]
   return request.make_response(pdf, headers=pdfhttpheaders)

Here,

rpg_quotation is the module name and rpg_quotation_software_setwise__report is report id.

This question has been flagged