[libreoffice-users] Re: how to create mailmerge with libre base only without using libre calc.

Le 02/02/2012 02:04, sonic a écrit :

Hi Sonic,

> Dear BRO, SIR,SIS,
> May I know is there any other alternative ways to create mail merge with
> libre base and generate report from libre base without opening other program
> like libre writer or libre calc to do it..
> which mean that , want to using 1 program only to do all the job that's
> libre base .

Short answer : for mailmerge, no. You must use Base in combination with 
Writer

If you want a report, you can :
(1) use the Oracle Report Builder, which is a built-in extension, 
accessible, for example, via a Base (ODB) file ;
(2) use a Calc file and design your own report using data ranges;
(3) use a Writer file, and insert your data fields from the table or 
query of your choice ;
(4) write an external program using python, javascript, beanshell, perl, 
php, etc to manipulate ODF compliant XML and interface that with your 
datasource.

> If there any tutorial or suggestion pls do let me know tQ your's help are
> much appreciated...


Information and tutorials for manipulating ODF XML :

http://stackoverflow.com/questions/3477597/how-to-generate-odf-charts-with-perl

http://search.cpan.org/~jmgdoc/OpenOffice-OODoc-2.125/OODoc/Intro.pod

http://cpanforum.com/threads/3039

http://www.opendocsociety.org/tools/odf-tools/

http://letscript.wordpress.com/2011/09/30/from-mysql-to-opendocument-format-with-perl/


Information about using Calc or the Report Builder to make reports :

http://wiki.services.openoffice.org/wiki/SUN_Report_Builder/Documentation

http://user.services.openoffice.org/en/forum/viewtopic.php?f=75&t=18511

http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=23727


Alex


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted