BITTE helfen Sie uns HEUTE mit einer SPENDE
Helfen Sie das LibreOffice Forum zu erhalten!
> KEINE WERBUNG FÜR REGISTRIERTE BENUTZER!<
Ihre Spende wird für die Deckung der laufenden Kosten sowie den Erhalt und Ausbau 🌱 des LibreOffice Forums verwendet.
🤗 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) 244-mal heruntergeladen
LibreOffice 4.3.7
Mac OSX 10.7.5
Mac OSX 10.7.5
Re: BaseReportExtension Support und Discussion [en,de]
excellent work! I can do the update tomorrow! Grazie!
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) 225-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) 239-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 nutzen:
Bitte beteiligen Sie sich mit 7 Euro pro Monat und helfen uns bei unserem Budget für das Jahr 2024.
Einfach per Kreditkarte oder PayPal.
Als Dankeschön werden Sie im Forum als LO-SUPPORTER gekennzeichnet.
❤️ Vielen lieben Dank für Ihre Unterstützung ❤️