I have a database with several tables, some of them related to each others with foreign keys.
When using the Report Builder, I do not manage to display “related” information. I am only able to display the foreign keys and the value of the other table.
The wizard (of the Report Builder) does not ask me the table I want to use for the report (but I can change it after in the properties, but only choose one table at a time).
The report does not seem to “see” the other tables. I can only use functions on the current fields of the table.
The LO help is not very helpful on this subject.
After some time, I found a workaround: create a complicated SQL query like:
SELECT movies.title,actors.name,actors.surname,role.character FROM movies, actors, role WHERE role.idMovie=movies.idMovie and actors.idActor=role.idActor
Save the query and then apply your report to this query. All the displayed fields seem accessible. However, what is the point to define relationships in the database if everything else (reports and forms) must be done manually?