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?
| 相关帖文 | 回复 | 查看 | 活动 | |
|---|---|---|---|---|
|
5
3月 15
|
14005 | ||
|
1
3月 15
|
5422 | ||
|
0
3月 15
|
6034 | ||
|
0
12月 24
|
9449 | ||
|
3
9月 24
|
21602 |
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!