JoeLibreOffice's profile - activity

I have had a similar problem creating a report in design mode. If 2 of your data elements have overlapping xy space pos

I want to thank Ratsinger for his patience and suggestions. Unfortunately, I have not been able to get LibreOffice Base

I am having a problem creating reports using the LibreOffice Base Report application.

I am trying to migrate an Access database to Base. I have migrated the 3 tables into an embedded Base odb file, and I have a working query. I am now trying to create forms and reports.

I am moving from an old XP systems to a new dual boot system: Window 7 Pro, and Linux Mint 17.2.

Some key new system parameters: cpu i7, 16 GB memory, and 1 TB hardfile. So, I do not think my problems are due to the lack of system resources.

Linux Mint 17.2: LibreOffice v5.4.5.1 and Java 1.7.0_151

Win 7 Pro: LibreOffice v5.4.5.1 and Java 1.8.0_161

I will try to summary my crash experiences since the details are too long for posting at this time.

1. I migrated the 3 tables to Base (embedded database).
2. I created the query using the parameter LIKE code suggestion from Ratslinger (Mar 13th).
3. Depending upon which database copy and when I was working on the report, I only have the report wizard option available.  When I first started I think I had both the “design” and “wizard” options.
4. I created a report using the wizard and saved the report as rpt_Report_01.
5. I started editing the report with periodic saves of the report.
    ◦ Added 3 levels of grouping
    ◦ Added group subtotals using =Accumulate(field) for the 3 groupings.
    ◦ Adjusted font size for the data to 8.
    ◦ Adjusted field widths to try to fit my data on the page.
6. During the editing process, I got multiple crashes.  I think the crashes are related to overlapping data fields as I was adjusting data field placements and widths.
7. Selected “Recovery” when reopening the database.  This may not have been a good choice based on researching some other AskLibreOffice postings.  “Recovery” only recovers some of the information in the database.
8. I lost my existing rpt_Report_01 after the recovery, and I needed to recreate the report.
9. At some point, after one of the recoveries, I got a dialog box saying I needed to install libreoffice-report-builder.
10. Installed libreoffice-report-builder using the Linux Mint Software Manager.
11. The libreoffice-report-builder-bin is also currently installed (not a new add).  I think this came with the LibreOffice v5.4.xx install.
12. Now I have a different report wizard format.  This may be an older Sun version?
13. The new report wizard creates a report with several different format options.
14. However, the edit mode of the new report does not seem to provide the ability to change groupings, nor add subtotals for the existing groups.

What should be my next steps:

1. Uninstall the libreoffice-report-builder?
2. Uninstall LibreOffice and reinstall?  Which version to reinstall?
3. Is LibreOffice Base Report stable and usable?
4. What are the reporting alternatives for embedded databases?
5. Any other suggestions?

I am trying to migrate an ACCESS database from the old XP system to the New Desktop, preferably using the Linux Mint ope

I think my LiberOffice installation has a problem. The radio buttons and check boxes are missing on the various Tools &

Thank you for the SQL Tutorial link. I think I will find it useful.

Ratslinger, thank you for your help. java version "1.8.0_171", Java(TM) SE Runtime Environment (build 1.8.0_171-b11), J

I am back online after breaking a leg (no fun). I removed LibreOffice and the user profiles, reinstalled LibreOffice 5

Ratslinger, thank you for your Mar 22nd response. You provided several suggestions that will take me a little time to im

I use the free GIMP software to add text, and other items to my jpg and png images. GIMP is not limited to just jpg and

Base - Report - Crashes I am having a problem creating reports using the LibreOffice Base Report application. I am tryi

I found multiple sample databases on the TheFrugleComputerGuy web site. http://thefrugalcomputerguy.com/tutorials.php

I am having several problems with the migration of my Medical Access database to Base. I think I have migrated the 3 tables from Access to Base, but I am having a problem replicating my queries and reports.

Parameter Query

In Access, I created a query using the following criteria to pull data from the tables based on a user entered selection prompt. I am selecting on the ClaimNum data field.

Like [Enter ClaimNum] & “*”

When I run the Access query, a dialog box appears and I can enter the data. Examples, 1701, 1710A, or using wildcards, 17. The “17” entry will pull all of the records beginning with “17”.

In Base, I have not been able to duplicate the wildcard functionality. The ClaimNum data field is VARCHAR length 100, and I also tried VARCHAR_IGNORECASE.

In Base, I entered the following criteria in the ClaimNum data column.

LIKE EnterClaimNum

When I run the query, I get the parameter prompt “EnterClaimNum” and I can enter the selection data. However, this only works if I enter the complete data string. Examples, 1701, or 1710A. The wildcard entry return an empty query. I tried 17*, 17%, 17_, with and without enclosed “ “.

I am using LibreOffice v5.4.5.1 and Java 1.8.0_151 on an XP operating system which I want to migrated to a newer system.

The new system is a dual boot system.

Linux Mint 17.2, LibreOffice v5.4.5.1 and Java 1.7.0_151

Win 7 Pro, LibreOffice v5.4.5.1 and Java 1.8.0_161

The problem occurs on the XP system and both new system configurations.

Thank you in advance for your assistance.

Thank you for your code suggestion, and I deleted the access2base tag that was in error. When I entered that code into

BASE Query Criteria Problem I am having several problems with the migration of my Medical Access database to Base. I th