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?
Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.
Inscribirse| Publicaciones relacionadas | Respuestas | Vistas | Actividad | |
|---|---|---|---|---|
|
5
mar 15
|
15495 | ||
|
1
mar 15
|
7453 | ||
|
0
mar 15
|
7573 | ||
|
0
ene 26
|
26 | ||
|
1
oct 25
|
8614 |
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!