Created attachment 104922 [details] report with notes fields of sub-tables are choosen in form, but the are represented in the report with digits One note in the attachment gives an additional advice, that selected frame is not stored. See next bug
Thanks Albrecht.
Confirmed. 'Visible' field of the related table isn't used.
Is this using a field with a bound column? Might be difficult to fix in KReport quickly as it has no concept of bound values ... can you not join the fields in a query for the report, and display the field containing the text as required?
Am Donnerstag, 15. Juni 2017, 22:53:13 CEST schrieben Sie: > https://bugs.kde.org/show_bug.cgi?id=378560 > > --- Comment #3 from Adam Pigg <adam@piggz.co.uk> --- > Is this using a field with a bound column? Might be difficult to fix in > KReport quickly as it has no concept of bound values ... can you not join > the fields in a query for the report, and display the field containing the > text as required? @Adam, for your first question have a look, on my file under https://www.magentacloud.de/share/ulf2n.9mdj (not compressed, it works not for me) I'm not familiar what you mean. Can you make out of my db a template, that I can understand hwo to make it? Thanks! Albrecht
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.
Just a reminder. Ideal fix in reports would be to use the visible field for the display. KDb and thus Kexi includes both bound and visible fields when needed, this way in case of editable content bound+visible fields can be used for combo boxes.
Created attachment 106123 [details] Visible column / field Visible field: I mean this in the table designer
I could not find what you showed in the picture
@Albrecht could you please show screenshot of your table designer's property pane? You can't find the lookup column tab or?
Created attachment 107444 [details] Bild2 Am Dienstag, 22. August 2017, 12:21:08 CEST schrieben Sie: > https://bugs.kde.org/show_bug.cgi?id=378560 > > --- Comment #9 from Jarosław Staniek <staniek@kde.org> --- > @Albrecht could you please show screenshot of your table designer's property > pane? > > You can't find the lookup column tab or? Here is the basic table and a subtable
Created attachment 107445 [details] Bild1
Thanks but I mean not data but design window. Right side of your window. https://bugsfiles.kde.org/attachment.cgi?id=106123
Created attachment 114930 [details] example showing problem
See the attached example, showing that queries exhibit the same behaviour as reports. masted contains fields linked to child query1 shows problem query2 shows how I would normally structure my report queries to get child data into a report. If you are sure this is a missing feature I can look further into it, but maybe the query plugin also need fixed?
Comment on attachment 114930 [details] example showing problem sorry, I cannot open the file. In the error-report are no details. I only can use kexi 3.1.0 And sorry, I cannot translate/understand "masted" contains fields linked to child
odd, it opens in 3.1 here
Created attachment 114938 [details] my problem to open test1.kexi
Created attachment 114939 [details] my problem to open test1.kexi (repetition)
@Albrecht the file is called test1.kexi not test.kexi and has md5sum = a6618b7cf218fbe47713ef5fb75d691c.
@Adam I confirm the issue in quwry1 in KEXI 3.1.1-pre and 3.2 (master).
my md5sum: kexi]$ md5sum test1.kexi e5a0c3d608c5c4b5f594c26d2ffd673f test1.kexi your summ a6618b7cf218fbe47713ef5fb75d691c ??
e5a0c3d608c5c4b5f594c26d2ffd673f, right (after opening it in KEXI it changes) Since the file is correct maybe you have problems with desktop integration so clicking on the file won't work? Could you please run KEXI, and open the file in it?
I did both after I erased the earlier test1.kexi, first opening in kexi. The message is the same as before.
@Albrecht without closing KEXI, are you able to 1. create an empty KEXI project file 2. close it, 3. open it?
cannot open it, the same message. I thought I wrote it some weeks ago. But lastly i could, so may be i didn't report it. WHY it worked ? I don't know. Somehow ...
So your system has some installation issue of KEXI, right? Do you have any paths set, probably globally? If so this is off topic in this bug. I propose to continue on KEXI forum, please start a new thread so we can help.