Migrated from windows 10 to linux mint, libreoffice unable to open documents to print reports

[alanon]

Hi guys,
I’ve recently migrated to Linux Mint from Windows 10. POINT OF CLARIFICATION: I’ve been using LibreOffice products on windows since windows 10. So the complete database was written in LibreOffice Base prior the migration from Windows to Linux Mint. Everything is working as it should, until it’s time to print year-end reports on my database.

I’m getting an error and I don’t know how to fix it. Can you guys help please? Thank you in advance!

Here are the details of the error (the same regardless of which report I try to run) (multiple edits as I’m uploading the pics 1 at a time and a point of clarification)…

[alanon]

upon further investigating, I found the issue.

Linux Mint comes with LibreOffice as part of its distribution. However BASE is not complete or is fully included with the installation of LibreOffice on Linux Mint. After digging in, I determined I best uninstall all components of the LibreOffice application then reinstall it complete.

Once I reinstalled it, all the reports worked like they should and did in Windows 10. Still need to figure out how to keep LibreOffice complete up-to-date. I don’t see any option anywhere within the application, although in Windows it had the option in the Help menu if I remember correctly.

[RobertG]

If you have installed the version of LO, which is supported by your distribution (not LibreOffice), it will be updated by the package manager like all other applications will be updated.
If you have separate installed packages directly downloaded from www.libreoffice.org you could set
Tools → Options → LibreOffice → OnlineUpdate
to check for updates and download the packages to where you want. Installation of this updates isn’t provided under Linux.

[Wanderer]

@alanon

BASE is not complete or is fully included with the installation of LibreOffice on Linux Mint.

This is a typical problem in Linux. Many maintainers try to keep Java out of their installs. Some remove Base completly, some only components actually using Java. As the default database HSQLDB and the report-generator are written in Java they need to be installed separately.
.
Second problem is to find out how your LibreOffice is installed:
Debian uses apt, Ubuntu a snap and Mint avoids Snap, so they choose between apt and flatpack…

@alanon

determined I best uninstall all components of the LibreOffice application then reinstall it complete.

For apt this is not necessary. It will see the dependencies and what is already installed. Flatpacks are always black-boxes, no partly installs intended…

@alanon

I don’t see any option anywhere within the application, although in Windows it had the option in the Help menu if I remember correctly

Both correct: Linux will usually update all your software directly, if your distribution provides the updates (Attention: Often only minor/security-updates are provided. Some Ubuntu-LTS use still LibreOffice 6.x and will never get 7.x via apt unless you upgrade the whole distribution. Snap/Flatpack is a way out of this, but price is often lack of integration in the OS.)
.
Windows had the manual or automatic check for new versions, but you had to install yourself. Since last year there are also automated updates possible (and active by default).