Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hello, I am trying to create a report using OpenOffice plugin. The problem I find is that when I create a new report it asks me to select a module, but it looks the plugin calls modules to classes so selecting just 1 class is not good for me because I need to retrieve data from several classes in my module.
Is there any workaround to this? Thanks a lot!
You need to have a foreign key column to access the other table, lets say we have Buildings & Employees tables, and we have a foreign key in employees from building, then you need to choose the Employees module when creating the report.
Now, you can access both tables Example: - Employee Name: [[ o.name ]] - Employee Building: [[ o.building_id.name ]]
Have a look at this custom module, it contains two reports DOWNLOAD
Thanks, so there must always be a relationship between the tables to be able to use both tables in the same report, is that right?
สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!
ลงชื่อ| Related Posts | ตอบกลับ | มุมมอง | กิจกรรม | |
|---|---|---|---|---|
|
5
มี.ค. 15
|
14010 | ||
|
1
มี.ค. 15
|
5428 | ||
|
0
มี.ค. 15
|
6035 | ||
|
0
ธ.ค. 24
|
9461 | ||
|
3
ก.ย. 24
|
21628 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
what is the exact tables/objects/classes you would like to retrieve data from?
Hello Anas, thanks for your help. I developed my own module, it has many tables. Lets say one is Buildings and one is Employees. I wish to be able in a single report to list the information on both tables. Is that currently possible? This is a report I need to generate each month, thats why it must include a lot of information. Thanks again!