Re: [Kexi] Kexi + Kugar
Matija Šuklje wrote: And another thing, that is either my fault or KexiReportPart's: Since (as far as I understand) I can only use one query for a report, I have put all of the relevant data into it. Which, coincidentally, means there are a few fields that have the same name, but are located in different tables. The problem that I get is that when I call these in the report separately I always get the same entry. Although I select the right column in the text dialog when I click ok it changes to the first one in the list with the same column name. Example: Let's say I have three tables with one field with the same name (IRL I have several of them, but the same goes for all). Let's name the tables 'table1' 'table2' and 'table3' and the problematic fields in all of them 'price'. Let's say these are the values for these fields: table1.price = 10 table2.price = 30 table3.price = 23 In the query the values are presented then as, which is correct: price = 10 price = 30 price = 23 In the KexiReportPart's text properties dialog I get a list with: list of other fields price list of other fields price list of other fields price If I then make three text fields and link each to the price column that is below the one I selected before, this is what I expect to have: text1 = price = 10(i.e. price 1) text2 = price = 30(i.e. price 2) text3 = price = 23(i.e. price 3) ...but this is what I get: text1 = price = 10(i.e. price 1) text2 = price = 10(i.e. price 1) text3 = price = 10(i.e. price 1) And when I go to text2 and text3 dialogs to change the column, I notice that KexiReportPart changed the price column I chose to the first/uppermost price column in the list. This happens every time, so I have no means to change it to the right column. Preferred solution: Selecting the querried fields/columns in a way that it distinguishes between tables. e.g. calling them table1.price, table2.price and table3.price (or something similar). What I'm affraid I'll have to do: Destroy my tables because I'll have to rename a few fields so they're unambigious although they're in separate tables :/ Cheers, Matija I'll look into this, and try to fix some bugs in the kexi1 versionbut the kexi2 version has much more features already ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi + Kugar
Dne četrtek 24. januarja 2008 je Jarosław Staniek napisal(a): It's good idea to use --enable-debug=full configure option to get better backtraces report of the same Kexi and KexiReportPart, only both compiled with full debuging flag. Cheers, Matija -- gsm: +386 41 849 552 e-mail: [EMAIL PROTECTED] www: http://matija.suklje.name aim: hookofsilver icq: 110183360 jabber/g-talk: [EMAIL PROTECTED] msn: [EMAIL PROTECTED] yahoo: matija_suklje (no debugging symbols found) Using host libthread_db library /lib/libthread_db.so.1. (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) [KCrash handler] #5 0x2b97c5218560 in KexiDB::Cursor::eof () from /usr/lib64/libkexidb.so.2 #6 0x2b97c9a5ae65 in orReportPrivate::renderDetailSection ( this=0xbba6e0, [EMAIL PROTECTED], pPainter=0x0, pPrinter=0x0) at openreports.cpp:954 #7 0x2b97c9a5cd6c in orReport::render (this=0xb3f4c0, pPainter=0x0, pPrinter=0x0, pageNum=1) at openreports.cpp:1910 #8 0x2b97c9a5d050 in orReport::pageCount (this=0xb3f4c0) at openreports.cpp:2290 #9 0x2b97c95f9e99 in KexiReportView (this=0xcd1a80, win=0x9d6890, parent=0xaf1da0, name=0xb059c0 Racuni_sostanovalcem, conn=0xbd2c50) at kexireportview.cpp:36 #10 0x2b97c95f8c11 in KexiReportPart::createView (this=0xcc9520, parent=0xaf1da0, dialog=0xce37c0, [EMAIL PROTECTED], viewMode=1) at kexireportpart.cpp:68 #11 0x2b97c4d08737 in KexiDialogBase::switchToViewMode () from /usr/lib64/libkexicore.so.2 #12 0x2b97c4d1081f in KexiPart::Part::openInstance () from /usr/lib64/libkexicore.so.2 #13 0x2b97c4cffd9b in KexiProject::openObject () from /usr/lib64/libkexicore.so.2 #14 0x2b97c3afb26c in KexiMainWindowImpl::openObject () from /usr/lib64/libkeximain.so.2 #15 0x2b97c3af2e68 in KexiMainWindowImpl::openObjectFromNavigator () from /usr/lib64/libkeximain.so.2 #16 0x2b97c3af2f0e in KexiMainWindowImpl::openObjectFromNavigator () from /usr/lib64/libkeximain.so.2 #17 0x2b97c3afe7ab in KexiMainWindowImpl::qt_invoke () from /usr/lib64/libkeximain.so.2 #18 0x2b97bf5b51fc in QObject::activate_signal () from /usr/qt/3/lib64/libqt-mt.so.3 #19 0x2b97c4556b2b in KexiBrowser::openOrActivateItem () from /usr/lib64/libkexiextendedwidgets.so.2 #20 0x2b97c4559135 in KexiBrowser::qt_invoke () from /usr/lib64/libkexiextendedwidgets.so.2 #21 0x2b97bf5b51fc in QObject::activate_signal () from /usr/qt/3/lib64/libqt-mt.so.3 #22 0x2b97bf8b60ef in QListView::doubleClicked () from
Re: [Kexi] Kexi + Kugar
Dne ponedeljek 21. januarja 2008 je PiggZ napisal(a): And you can try out the kexi1.6 version [...] Kexi 1.6.3 installed from Gentoo's amd64 stable portage tree KexiReportPart 0.4 installed by ./configure --without-arts make make install KexiReportWriter seems to work OK-ish, but when I load the report in Kexi it crashes. I'm attaching the KDE debug output. Cheers, Matija -- gsm: +386 41 849 552 e-mail: [EMAIL PROTECTED] www: http://matija.suklje.name aim: hookofsilver icq: 110183360 jabber/g-talk: [EMAIL PROTECTED] msn: [EMAIL PROTECTED] yahoo: matija_suklje (no debugging symbols found) Using host libthread_db library /lib/libthread_db.so.1. (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) [KCrash handler] #5 0x2b6159811490 in KexiDB::Cursor::eof () from /usr/lib64/libkexidb.so.2 #6 0x2b615d4ca666 in orReportPrivate::renderDetailSection () from /usr/kde/3.5/lib/libkrptrenderer.so.0 #7 0x2b615d4cc83f in orReport::render () from /usr/kde/3.5/lib/libkrptrenderer.so.0 #8 0x2b615d4cd8ac in orReport::pageCount () from /usr/kde/3.5/lib/libkrptrenderer.so.0 #9 0x2b615d07f206 in KexiReportView::KexiReportView () from /usr/kde/3.5/lib/kde3/kexireportpart.so.0 #10 0x2b615d07e2ff in KexiReportPart::createView () from /usr/kde/3.5/lib/kde3/kexireportpart.so.0 #11 0x2b6159510dd3 in KexiDialogBase::switchToViewMode () from /usr/lib64/libkexicore.so.2 #12 0x2b615951cbdd in KexiPart::Part::openInstance () from /usr/lib64/libkexicore.so.2 #13 0x2b615950e78a in KexiProject::openObject () from /usr/lib64/libkexicore.so.2 #14 0x2b615874829d in KexiMainWindowImpl::openObject () from /usr/lib64/libkeximain.so.2 #15 0x2b6158736aa5 in KexiMainWindowImpl::openObjectFromNavigator () from /usr/lib64/libkeximain.so.2 #16 0x2b6158736b9e in KexiMainWindowImpl::openObjectFromNavigator () from /usr/lib64/libkeximain.so.2 #17 0x2b6158750d64 in KexiMainWindowImpl::qt_invoke () from /usr/lib64/libkeximain.so.2 #18 0x2b61545121fc in QObject::activate_signal () from /usr/qt/3/lib64/libqt-mt.so.3 #19 0x2b6159091868 in KexiBrowser::openOrActivateItem () from /usr/lib64/libkexiextendedwidgets.so.2 #20 0x2b615909813c in KexiBrowser::qt_invoke () from /usr/lib64/libkexiextendedwidgets.so.2 #21 0x2b61545121fc in QObject::activate_signal () from /usr/qt/3/lib64/libqt-mt.so.3 #22 0x2b61548130ef in QListView::doubleClicked ()
Re: [Kexi] Kexi + Kugar
Matija Šuklje said the following, On 2008-01-23 23:48: Dne ponedeljek 21. januarja 2008 je PiggZ napisal(a): And you can try out the kexi1.6 version [...] Kexi 1.6.3 installed from Gentoo's amd64 stable portage tree KexiReportPart 0.4 installed by ./configure --without-arts make make install It's good idea to use --enable-debug=full configure option to get better backtraces -- regards / pozdrawiam, Jaroslaw Staniek Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on Kexi KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi) KDE Libraries for MS Windows (http://windows.kde.org) ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi + Kugar
Dne četrtek 24. januarja 2008 je Jarosław Staniek napisal(a): It's good idea to use --enable-debug=full configure option to get better backtraces In Kexi? ...I think Gentoo's equivalent is the USE=debug flag. Cheers, Matija -- gsm: +386 41 849 552 e-mail: [EMAIL PROTECTED] www: http://matija.suklje.name aim: hookofsilver icq: 110183360 jabber/g-talk: [EMAIL PROTECTED] msn: [EMAIL PROTECTED] yahoo: matija_suklje signature.asc Description: This is a digitally signed message part. ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi + Kugar
Dne četrtek 24. januarja 2008 je Jarosław Staniek napisal(a): KexiReportPart. You have mentioned KexiReportPart 0.4 installed by ./configure Yes, but then again, the thing that crashes is Kexi, not KexiReportWriter ...I'll retry anyway. Btw, does make clean clean out also the binaries installed by make install or just the local ones? Cheers, Matija -- gsm: +386 41 849 552 e-mail: [EMAIL PROTECTED] www: http://matija.suklje.name aim: hookofsilver icq: 110183360 jabber/g-talk: [EMAIL PROTECTED] msn: [EMAIL PROTECTED] yahoo: matija_suklje signature.asc Description: This is a digitally signed message part. ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi + Kugar
Dne ponedeljek 21. januarja 2008 je PiggZ napisal(a): And you can try out the kexi1.6 version from http://www.kde-apps.org/content/show.php/Kexi+Report+Part Thanks both of you for the info :] I have tried it, managed to compile it with --disable-arts and ran it, but so far I haven't succeded in making it usable yet. And remember, any feedback can only improve it! Will do ;) Cheers, Matija -- gsm: +386 41 849 552 e-mail: [EMAIL PROTECTED] www: http://matija.suklje.name aim: hookofsilver icq: 110183360 jabber/g-talk: [EMAIL PROTECTED] msn: [EMAIL PROTECTED] yahoo: matija_suklje signature.asc Description: This is a digitally signed message part. ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi + Kugar
Matija Šuklje said the following, On 2008-01-20 17:31: I just started managing our house's bills in Kexi and wanted to use Kugar to produce reports for it ...and was surprised to notice that Kugar uses its own (and only its own) DB. Kugar is obsolete in part due to its architecture. And predicting long ago we have not been using it for Kexi. A new OpenRPT-based tool is in development (by Adam Pigg) for KOffice 2. http://www.piggz.co.uk/kexirpt4.png http://www.piggz.co.uk/kexirpt_designer1.png Is there a half-way normal way of using Kexi and Kugar Sorry, there isn't together and if not, what would be a better idea? For now use external reporting tools like OpenRPT. We have written MANY links for you: http://kexi-project.org/wiki/wikiview/index.php?RelatedProjects#Reporting_Tools -- regards / pozdrawiam, Jaroslaw Staniek Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on Kexi KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi) KDE Libraries for MS Windows (http://windows.kde.org) ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi