🙏 Helfen Sie jetzt mit, unser LibreOffice Forum zu erhalten! 🙏
Mit Ihrer Spende sichern Sie den Fortbestand, den Ausbau und die laufenden Kosten dieses Forums. 🌱
🍀 Jeder Beitrag zählt – vielen Dank für Ihre Unterstützung!🍀
>> Dank Ihrer Unterstützung -> Keine Werbung für alle registrierten LibreOffice-Forum User! <<
🤗 Als Dankeschön werden Sie im Forum als LO-SUPPORTER gekennzeichnet. 🤗
BaseReportExtension Support und Discussion [en,de]
- charlie.it
- Beiträge: 14
- Registriert: Sa 7. Jan 2017, 07:56
Re: BaseReportExtension Support und Discussion [en,de]
Ok, thank you.
I also prepared the .odt file in Italian, if you want to add it in the extension documentation.
I leave to you to complete the extension with texts in Italian that i wrote.
I also prepared the .odt file in Italian, if you want to add it in the extension documentation.
I leave to you to complete the extension with texts in Italian that i wrote.
- Dateianhänge
-
- guida_rapida_basereportextension.odt
- (496 KiB) 281-mal heruntergeladen
LibreOffice 4.3.7
Mac OSX 10.7.5
Mac OSX 10.7.5
Re: BaseReportExtension Support und Discussion [en,de]


g
2008 LucidL./MaverickM./WinXP LibreOffice 3.3.2 > 02/13 LinuxMint13/Xubuntu > 09/13 Debian Wheezy+LO3.5.4.2 > 01/15 Debian Jessie KDE+LO4.3.3.2/Mint17 openbox auf USB+LO4.2.8.2 > 03/16 ArchLin & LO5.1+ff > 02/18 Kubuntu
2008 LucidL./MaverickM./WinXP LibreOffice 3.3.2 > 02/13 LinuxMint13/Xubuntu > 09/13 Debian Wheezy+LO3.5.4.2 > 01/15 Debian Jessie KDE+LO4.3.3.2/Mint17 openbox auf USB+LO4.2.8.2 > 03/16 ArchLin & LO5.1+ff > 02/18 Kubuntu
- charlie.it
- Beiträge: 14
- Registriert: Sa 7. Jan 2017, 07:56
Re: BaseReportExtension Support und Discussion [en,de]
Ciao @gogo,
I do not understand why I get SQL error with the query of this file. If instead of the name of the query as Value for the table of the file .ott, use its SQL content, everything works.
Thanks.
I do not understand why I get SQL error with the query of this file. If instead of the name of the query as Value for the table of the file .ott, use its SQL content, everything works.
Thanks.
- Dateianhänge
-
- Country.odb.zip
- (22.91 KiB) 267-mal heruntergeladen
LibreOffice 4.3.7
Mac OSX 10.7.5
Mac OSX 10.7.5
Re: BaseReportExtension Support und Discussion [en,de]
Ciao Charlie
what error exactly?
I've attached a file which contains 2 *.otts and the odt-file.
In both otts there're 2 tables, the first is referring to the queryname, the second takes the SQL-String.
Extract them to one directory and open the database, Formular1 has a button to open a report based on BRX_Test01.ott.
If you open BRX_Test02.ott klick on the Button and both tables will fill (if any of your Country.odb's is a registered datasource named "Country").
what error exactly?
I've attached a file which contains 2 *.otts and the odt-file.
In both otts there're 2 tables, the first is referring to the queryname, the second takes the SQL-String.
Extract them to one directory and open the database, Formular1 has a button to open a report based on BRX_Test01.ott.
If you open BRX_Test02.ott klick on the Button and both tables will fill (if any of your Country.odb's is a registered datasource named "Country").
- Dateianhänge
-
- Country.odb_with_otts.zip
- (43.69 KiB) 270-mal heruntergeladen
g
2008 LucidL./MaverickM./WinXP LibreOffice 3.3.2 > 02/13 LinuxMint13/Xubuntu > 09/13 Debian Wheezy+LO3.5.4.2 > 01/15 Debian Jessie KDE+LO4.3.3.2/Mint17 openbox auf USB+LO4.2.8.2 > 03/16 ArchLin & LO5.1+ff > 02/18 Kubuntu
2008 LucidL./MaverickM./WinXP LibreOffice 3.3.2 > 02/13 LinuxMint13/Xubuntu > 09/13 Debian Wheezy+LO3.5.4.2 > 01/15 Debian Jessie KDE+LO4.3.3.2/Mint17 openbox auf USB+LO4.2.8.2 > 03/16 ArchLin & LO5.1+ff > 02/18 Kubuntu
- charlie.it
- Beiträge: 14
- Registriert: Sa 7. Jan 2017, 07:56
Re: BaseReportExtension Support und Discussion [en,de]
Oh! thank you.
I found my error with your help: I wrote the error string: Cuntry.select * from “WorldAreaReport” instead: WorldAreaReport.
Thank you again.
I found my error with your help: I wrote the error string: Cuntry.select * from “WorldAreaReport” instead: WorldAreaReport.
Thank you again.
LibreOffice 4.3.7
Mac OSX 10.7.5
Mac OSX 10.7.5
- charlie.it
- Beiträge: 14
- Registriert: Sa 7. Jan 2017, 07:56
Re: BaseReportExtension Support und Discussion [en,de]
Ciao,
also point out this thread from me open on the English AOO forum: https://forum.openoffice.org/en/forum/v ... 86#p406161.
@Villeroy compares your extension with the one written by him in Python, and more ...
also point out this thread from me open on the English AOO forum: https://forum.openoffice.org/en/forum/v ... 86#p406161.
@Villeroy compares your extension with the one written by him in Python, and more ...
LibreOffice 4.3.7
Mac OSX 10.7.5
Mac OSX 10.7.5
Re: BaseReportExtension Support und Discussion [en,de]
thanks - I didn't kow about his extension - wrote that over there...
g
2008 LucidL./MaverickM./WinXP LibreOffice 3.3.2 > 02/13 LinuxMint13/Xubuntu > 09/13 Debian Wheezy+LO3.5.4.2 > 01/15 Debian Jessie KDE+LO4.3.3.2/Mint17 openbox auf USB+LO4.2.8.2 > 03/16 ArchLin & LO5.1+ff > 02/18 Kubuntu
2008 LucidL./MaverickM./WinXP LibreOffice 3.3.2 > 02/13 LinuxMint13/Xubuntu > 09/13 Debian Wheezy+LO3.5.4.2 > 01/15 Debian Jessie KDE+LO4.3.3.2/Mint17 openbox auf USB+LO4.2.8.2 > 03/16 ArchLin & LO5.1+ff > 02/18 Kubuntu
- charlie.it
- Beiträge: 14
- Registriert: Sa 7. Jan 2017, 07:56
Re: BaseReportExtension Support und Discussion [en,de]
Ciao, I'm still here to demand an explanation
.
I can not get to work the custom property „brx.save_to_url“.
Can you please post a file with an example where it works?
Thanks.

I can not get to work the custom property „brx.save_to_url“.
Can you please post a file with an example where it works?
Thanks.
LibreOffice 4.3.7
Mac OSX 10.7.5
Mac OSX 10.7.5
Re: BaseReportExtension Support und Discussion [en,de]
sry - there's a mismatch between documentation and code: use brx.savetourl instead of brx.save_to_url!
g
2008 LucidL./MaverickM./WinXP LibreOffice 3.3.2 > 02/13 LinuxMint13/Xubuntu > 09/13 Debian Wheezy+LO3.5.4.2 > 01/15 Debian Jessie KDE+LO4.3.3.2/Mint17 openbox auf USB+LO4.2.8.2 > 03/16 ArchLin & LO5.1+ff > 02/18 Kubuntu
2008 LucidL./MaverickM./WinXP LibreOffice 3.3.2 > 02/13 LinuxMint13/Xubuntu > 09/13 Debian Wheezy+LO3.5.4.2 > 01/15 Debian Jessie KDE+LO4.3.3.2/Mint17 openbox auf USB+LO4.2.8.2 > 03/16 ArchLin & LO5.1+ff > 02/18 Kubuntu
- charlie.it
- Beiträge: 14
- Registriert: Sa 7. Jan 2017, 07:56
Re: BaseReportExtension Support und Discussion [en,de]
Same result, unfortunately. What does it mean "report is set invisible" ?
LibreOffice 4.3.7
Mac OSX 10.7.5
Mac OSX 10.7.5
An alle, die das LibreOffice-Forum gern nutzen und unterstützen wollen:
Bitte helfen Sie uns mit 7 Euro pro Monat.
Durch Ihren Beitrag tragen Sie dazu bei, unsere laufenden Kosten für die kommenden Monate zu decken.
Unkompliziert per Kreditkarte oder PayPal.
Als ein kleines Dankeschön werden Sie im LO-Forum als SUPPORTER gekennzeichnet.