[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 Jarosław Staniek changed: What|Removed |Added Resolution|WAITINGFORINFO |WORKSFORME -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 Jarosław Staniek changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 Jarosław Staniek changed: What|Removed |Added Target Milestone|3.1.1 |--- Resolution|--- |WAITINGFORINFO Status|CONFIRMED |RESOLVED -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 Jarosław Staniek changed: What|Removed |Added Target Milestone|3.1 |3.1.1 -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 Jarosław Staniek changed: What|Removed |Added Assignee|kexi-b...@kde.org |a...@piggz.co.uk -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #26 from Jarosław Staniek --- 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. -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #25 from Albrecht Will --- 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 ... -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #24 from Jarosław Staniek --- @Albrecht without closing KEXI, are you able to 1. create an empty KEXI project file 2. close it, 3. open it? -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #23 from Albrecht Will --- I did both after I erased the earlier test1.kexi, first opening in kexi. The message is the same as before. -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #22 from Jarosław Staniek --- 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? -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #21 from Albrecht Will --- my md5sum: kexi]$ md5sum test1.kexi e5a0c3d608c5c4b5f594c26d2ffd673f test1.kexi your summ a6618b7cf218fbe47713ef5fb75d691c ?? -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #20 from Jarosław Staniek --- @Adam I confirm the issue in quwry1 in KEXI 3.1.1-pre and 3.2 (master). -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #19 from Jarosław Staniek --- @Albrecht the file is called test1.kexi not test.kexi and has md5sum = a6618b7cf218fbe47713ef5fb75d691c. -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #18 from Albrecht Will --- Created attachment 114939 --> https://bugs.kde.org/attachment.cgi?id=114939&action=edit my problem to open test1.kexi (repetition) -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #17 from Albrecht Will --- Created attachment 114938 --> https://bugs.kde.org/attachment.cgi?id=114938&action=edit my problem to open test1.kexi -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #16 from Adam Pigg --- odd, it opens in 3.1 here -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #15 from Albrecht Will --- Comment on attachment 114930 --> https://bugs.kde.org/attachment.cgi?id=114930 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 -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #14 from Adam Pigg --- 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? -- You are receiving this mail because: You are watching all bug changes.
[KEXI] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #13 from Adam Pigg --- Created attachment 114930 --> https://bugs.kde.org/attachment.cgi?id=114930&action=edit example showing problem -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #12 from Jarosław Staniek --- Thanks but I mean not data but design window. Right side of your window. https://bugsfiles.kde.org/attachment.cgi?id=106123 -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #11 from Albrecht Will --- Created attachment 107445 --> https://bugs.kde.org/attachment.cgi?id=107445&action=edit Bild1 -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #10 from Albrecht Will --- 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 --- > @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 -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #9 from Jarosław Staniek --- @Albrecht could you please show screenshot of your table designer's property pane? You can't find the lookup column tab or? -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #8 from Albrecht Will --- I could not find what you showed in the picture -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 Jarosław Staniek changed: What|Removed |Added Target Milestone|3.0.2 |3.1 -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #7 from Jarosław Staniek --- Created attachment 106123 --> https://bugs.kde.org/attachment.cgi?id=106123&action=edit Visible column / field Visible field: I mean this in the table designer -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #6 from Jarosław Staniek --- 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. -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #5 from Adam Pigg --- 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 watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #4 from Albrecht Will --- 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 --- > 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 -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 --- Comment #3 from Adam Pigg --- 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? -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 Jarosław Staniek changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |CONFIRMED --- Comment #2 from Jarosław Staniek --- Confirmed. 'Visible' field of the related table isn't used. -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 Jarosław Staniek changed: What|Removed |Added Target Milestone|--- |3.0.2 Priority|NOR |HI --- Comment #1 from Jarosław Staniek --- Thanks Albrecht. -- You are receiving this mail because: You are watching all bug changes.
[kexi] [Bug 378560] Reports show digits and not the fields when sub-tables are used
https://bugs.kde.org/show_bug.cgi?id=378560 Jarosław Staniek changed: What|Removed |Added Summary|the report contains digits |Reports show digits and not |and not the fields out of |the fields when sub-tables |sub-tables |are used CC||stan...@kde.org -- You are receiving this mail because: You are watching all bug changes.
