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
|
14667 | ||
|
1
3月 15
|
6272 | ||
|
0
3月 15
|
6746 | ||
|
1
10月 25
|
5589 | ||
|
0
12月 24
|
10506 |
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!