Se rendre au contenu
Menu
Cette question a été signalée
1 Répondre
4237 Vues

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!

Avatar
Ignorer

what is the exact tables/objects/classes you would like to retrieve data from?

Auteur

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!

Meilleure réponse

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

Avatar
Ignorer
Auteur

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?

Publications associées Réponses Vues Activité
5
mars 15
14005
1
mars 15
5425
0
mars 15
6035
0
déc. 24
9453
3
sept. 24
21605