Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

I have set group by in field Quotation / Order report in 7.0?

By
Farid Ghanchi
on 6/10/13, 11:01 PM 1,777 views

I have add one field category in my test module. Now I want to print report(quatation/order) and i have display product category wise print. Suppose 1.Services,2.Delivery Report will print in 10 products in services and 5 products in Delivery just like summurrywise

 
                     ITEM        |    Total
                     Services    |      10
                     Delivery    |       5
                     Total       |      15
Is this possible ?

1

Sudhir Arya (SA)

--Sudhir Arya (SA)--
10150
| 6 8 8
Ahmedabad, India
--Sudhir Arya (SA)--

Working as an OpenERP/Odoo developer and a Team Leader 

Top 5 Odoo contributor On Stackoverflow

LinkedIn

Blog

Stackoverflow

Sudhir Arya (SA)
On 6/11/13, 9:35 AM

You have to create your own report which will print reports Category wise.

I mean in report 1st table will be for Category A with its Products and 2nd table for Category B with its Products.

I have edit quatation/order default in sale. I have add field category in my new addons.

Farid Ghanchi
on 6/11/13, 9:39 AM

You mean you want to create one more table that contains Category Name and Total Number of Products in that category? Am I right?

Sudhir Arya (SA)
on 6/12/13, 3:11 AM

I have add one field categ_type in sale.order.line Now we print only this categ_type its contain no of product suppose Delivery 10 products. how I print this group_by. I hope you got it.

Farid Ghanchi
on 6/12/13, 4:50 AM
0
Farid Ghanchi
On 6/15/13, 8:57 AM

Solve my issue for in create one method retrive data from postgrey and set in to rml that return dict.

def get_val(self, obj):
        query = """
           SELECT  categ_type as name, sum(product_uom_qty * price_unit) as total
           FROM sale_order_line 
           WHERE order_id = %s GROUP BY categ_type
        """%(obj.id)
        self.cr.execute(query)
        data = self.cr.dictfetchall()
        for t in data:
           dict={'name' : t['name'], 'total' : t['total']}
           res.append(dict)
        return res 

repeatIn[o.get_val(o), 'p']

[[ p['name'] ]] [[ p['total'] ]]

Which script have you changed especially the place where you created this function.

sivhaga
on 12/12/13, 7:25 AM

In my custom module.Thanks

Farid Ghanchi
on 12/12/13, 8:43 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 6/10/13, 11:01 PM
Seen: 1777 times
Last updated: 3/16/15, 8:10 AM