odooodoo-8

odoo 8 remove sum of total in group by


I'm using odoo 8 and I want to remove the sum of the total in the group by. Here is my .py

class report_sales_weekly(osv.osv):
_name = "report.sales.weekly"
_description = "report sales weekly"

_columns = {
            'div_target_monthly':fields.float('Div Target'),
            'div_achievement':fields.float('Div Achievement'),
            }
def read_group(self, cr, uid, domain, fields, groupby, offset=0, limit=None, context=None, orderby=False):
    if 'div_target_monthly' in fields:
        fields.remove('div_target_monthly')
    return super(report_sales_weekly, self).read_group(cr, uid, domain, fields, groupby, offset, limit=limit, context=context, orderby=orderby)
report_sales_weekly()  

I found this script from https://www.odoo.com/forum/help-1/how-to-remove-sum-of-total-in-group-by-29666, but I get an error when I make grouping in the list page

TypeError: read_group() got an unexpected keyword argument 'lazy'

Any help please? Thank you


Solution

  • You have two errors here: offset called without offset= and bad definition of the base read_group of Odoo 8.

    Can you please try with this :

    class report_sales_weekly(osv.osv):
        _name = "report.sales.weekly"
        _description = "report sales weekly"
    
        _columns = {
                'div_target_monthly':fields.float('Div Target'),
                'div_achievement':fields.float('Div Achievement'),
                }
        def read_group(self, cr, uid, domain, fields, groupby, offset=0, limit=None, context=None, orderby=False, lazy=False):
            if 'div_target_monthly' in fields:
                fields.remove('div_target_monthly')
            return super(report_sales_weekly, self).read_group(cr, uid, domain, fields, groupby, offset=offset, limit=limit, context=context, orderby=orderby, lazy=lazy)
            # As stated in the comments, you can also not put offset=offset etc. but just the variables offset, limit, ... Thanks @Kenly
    # Also, why this line ? 
    # report_sales_weekly()
    

    Keep me updated :)