Sign in
Try it free

Odoo Help
Help
Ask a Question
0

How to create a report with a measure of type char?

v8 report
By
José
on 8/22/16, 9:14 AM • 864 views

Hello, I have Odoo 8.

I want to display a report like this:

Row: partner name

And for each partner name, display the balance and the date of the last payment.

This is my XML file:

<graph string="Lista de deudores" type="pivot">
       <field name="last_payment_date" type="measure" />
       <field name="balance" type="measure"/>
       <field name="partner" type="row"/>                 
</graph>

But the "last payment" col is empty. Why? If I try the PostgreSQL query it works OK, there is not the problem    

The problem is because the "last_payment_date" is of "date" type. I also try with "char" type. If I try with integer date (for example getting the day of the date) it works.

José
on 8/22/16, 9:28 AM

About This Community

This platform 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.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

Asked: 8/22/16, 9:14 AM
Seen: 864 times
Last updated: 8/22/16, 9:14 AM