LO-Base: Report with foreign keys?

[GC1]

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.

Moreover:

1. 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).

2. The report does not seem to “see” the other tables. I can only use functions on the current fields of the table.

3. The LO help is not very helpful on this subject.

4. 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?

[qubit1]

Hi @GC1,

Have you found a solution to your question? I can try to ping one of our contributors more familiar with Base if you’re still searching for an answer…