Re: [libreoffice-users] Re: Reports Libre Base

Peter,

First, I have both Apache OpenOffice (AOO) and LibreOffice (LO) 
installed on my Slackware Linux computer. I mostly use AOO, but when I 
do my database reports, I open up LO to process them with the LO Base 
Report Builder. I do this because AOO does not have a stable Report 
Builder (see below) and LO does. So far, in more than a decade of use, I 
have not had any document compatibility problems between the two apps. 
We can thank the Open Document people and how strongly the app writers 
conform to the Open Document standards for that.

In my experience, the database support file (the .odb file) that 
contains all the app support stuff and gui definitions for the database 
is compatible between the two apps. So, there should be nothing to do in 
your Base gui to switch. Actually, I copied my .odb file from AOO to use 
with LO when I installed LO and I keep them both in separate 
sub-directories, just to be sure either does not get corrupted from the 
other app. I makes a good backup too.

That said, I have no experience with the LO or AOO internal database 
server (aka "engine", "back end", etc.). I use the external Mariadb 
(MySQL) server for my databases, so switching the clients (AOO and LO) 
is not a problem for me. If you are using the internal database server, 
I would strongly suggest saving your database first and then opening it 
on AOO to see if it works. You can always restore the database with your 
saved database if things go terribly wrong.

Keep in mind that OpenOffice does not have a Report Builder bundled in 
like LibreOffice does. There is an old extension (Oracle Report Builder) 
available that is advertised as compatible up to AOO 3.x, but is claimed 
by some to still work with the latest AOO 4.x version. I have not tried 
it yet and even then, it may not be as stable or up-to-date as the one 
bundled in with LO.
https://extensions.openoffice.org/en/project/oracle-report-builder

HTH. Good luck.
Girvin


On 11/28/2017 12:31 PM, Peter wrote:
> Definitly a hard crash. When restarted it goes into a recovery 
> process.  If I install Open Office will it work with the Lire Base 
> data bases or would I need to export the data and recreate new data 
> bases?
>
> Peter
>
> On 29/11/17 06:47, Girvin Herr wrote:
> > Peter,
> >
> > What indication do you have that LO crashes?
> > Does it lock up or disappear (a hard crash)?
> >
> > If the former, LO may just be taking a long time to process 
> > something. Patience is a virtue. I have some reports that search on 
> > database string fields that are quite slow to process the report. I 
> > can go out and have a cup of coffee and maybe it will be done when I 
> > return.
> >
> > If the latter, there is a known security fix problem with Linux 
> > kernels later than about 4.4.75 and Java. This problem affected 
> > LibreOffice, but not OpenOffice, from my experience. There is a fix, 
> > but it is technical, regarding stack frame gap size settings. The fix 
> > is to add a kernel boot parameter to your booter (Lilo or Grub or 
> > whatever). If you updated your *buntu since LO last worked, this may 
> > be your problem.
> >
> > HTH.
> > Girvin Herr
> >
> >
> >
> > On 11/27/2017 09:25 PM, Peter wrote:
> > > Base is installed and for my financial database the only problem I 
> > > have is reports. I followed the advice and installed the packages. 
> > > This made no difference. When I open the data base and select a 
> > > previously defined report the data bases crashes. If  I use the 
> > > report creation facility when I select the report wizard again the 
> > > data base crashes.
> > >
> > > Does base log these failures and if so where can I look at it?
> > >
> > > My fishing data base opens but I cannot open fofms , tables , 
> > > queries etc.
> > >
> > > This problem with Base has occurred in the last 12 months.
> > >
> > > Any suggestions on what to do next will be gratefully received.
> > >
> > >
> > > Peter
> > >
> > >
> > >
> > >
> > > On 28/11/17 09:20, Keith Bates wrote:
> > > > I use Ubuntu 17.04 also, including the Libreoffice packages 
> > > > installed directly from Ubuntu. The default install excludes Base, 
> > > > and if you can't open a database, it seems like you don't have Base 
> > > > installed. sudo apt install libreoffice-base should fix that,
> > > >
> > > > For reports the packages you need are libreoffice-report-builder 
> > > > and libreoffice-report-builder-bin. Use sudo apt install 
> > > > libreoffice-report-builder* and they should install.
> > > >
> > > >
> > > > Keith
> > > >
> > > >
> > > > On 28/11/17 08:45, Peter wrote:
> > > > > I reinstalled Libre Office  Base from the Ubuntu repository. I 
> > > > > assumed that this wouls automatically install all necessary 
> > > > > packages. a=There is nothing that I can find in the__Ubuntu 
> > > > > Software Repository that appears to relate to reports for 
> > > > > LibreBase.  How can i find out what packages I have installed and 
> > > > > what packages are required forreports to work.  I have an old data 
> > > > > base which has not been uses since January 2015 which I tried to 
> > > > > open today. This will no longer open for any thing , no forms or 
> > > > > views or tables can be opened.
> > > > >
> > > > > Peter
> > > > >
> > > > > On 28/11/17 04:50, Robert Großkopf wrote:
> > > > > > Hi Peter,
> > > > > >
> > > > > > > Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2
> > > > > > >
> > > > > > > Ubuntu 16.4
> > > > > > >
> > > > > > > When I first found the problem I removed LibreBase and 
> > > > > > > reinstalled it
> > > > > > > but the problem with reportsremained the  same.
> > > > > > This is a special Ubuntu-version of LO. Have a look into your
> > > > > > packagemanager. Did you install all packages for the
> > > > > > libreoffice-report-builder? Have heard there isn't only one package,
> > > > > > which should be installed for reports with the Ubuntu-version of LO.
> > > > > >
> > > > > > Regards
> > > > > >
> > > > > > Robert


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