Ask Your Question

GC's profile - activity

2014-03-01 08:27:56 +0100 received badge  Popular Question (source)
2014-03-01 08:27:56 +0100 received badge  Notable Question (source)
2014-03-01 08:27:56 +0100 received badge  Famous Question (source)
2013-02-27 00:13:09 +0100 received badge  Student (source)
2012-11-03 17:04:07 +0100 asked a question LO-Base: Report with foreign keys ?

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?