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?
Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!
Registrera dig| Relaterade inlägg | Svar | Vyer | Verksamhet | |
|---|---|---|---|---|
|
5
mars 15
|
15495 | ||
|
1
mars 15
|
7453 | ||
|
0
mars 15
|
7579 | ||
|
0
jan. 26
|
26 | ||
|
1
okt. 25
|
8635 |
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!