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.

0

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

By
José
on 8/22/16, 9:14 AM 179 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

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

1 follower(s)

Stats

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