[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used

[Adam Pigg]

https://bugs.kde.org/show_bug.cgi?id=378560

--- Comment #5 from Adam Pigg <adam at piggz.co.uk> ---
Take a look at this modification
https://www.dropbox.com/s/u2c6w1vyzcxk49c/Meilensteine_2017-04-08_test.kexi?dl=0

I have added a table and query.  The query joins your original table and the
new table and changed the report source to the query, then changed on field in
the report to a field in the query, Erscheinung.

I hoped to not add the table, but because in your main table, the field type is
Text, and not Integer for the erscheinung field, it was not possible to join
your main table and z_erscheinung, so the new table is the same, but the id
field is type Text .... this is not optimal, it would be better if in your main
table, the type was int for the foreign key fields.

But it works, and shows how it can be done.

-- 
You are receiving this mail because:
You are the assignee for the bug.