Would it be possible you provide a minimal step by step process to reproduce this?

I am learning to use Base with postgresql and have been loosely following the Casanova tutorial and modifying this as required.  There have been no issues working with tables, queries and forms.
An issue arises when working with reports.  One of the reports listed by Casanova is a report on payments by patients where the grouping is used to calculate the total amount paid by a patient for a specified time period.  This is achieved by using the sorting and grouping function to calculate a group footer. In the group footer, a field using a function to calculate the accumulation of the payment amount of a group is inserted into the group footer.
Every time I have attempted to insert this, Libreoffice hangs and I have had to do a Force Quit to exit.  I have attempted a number of reports for this and have built a number of queries on which the report is based.  The queries appear fine.
I have not been able to progress past this step so my next approach is to:
1. repeat the exercise using the embedded hsql database to rule out potential issues with the use of postgresql.
2. If this still fails, I plan to revert to an earlier version of Libreoffice to see if the issue is still present.
Any input from other users of Base + Postgresql would be most welcome.
Mike

Forgot to mention that in all instances but one, Libreoffice hung and required a force quit.  Only once did Libreoffice crash and generate this automatic crash report.  I am uncertain how to follow up those instances where Libreoffice hangs to determine the cause of this but have assumed that it has got into a loop somewhere.
Mike

At least if you reproduce this with hsqldb, you may attach your odb file and provide step by step process to reproduce this.

I have created the tables, queries, and forms from the Casanova tutorial using HSQLDB and had no difficulty with any of these. Everything performed normally and there were no stability issues.
I have now started to create the reports.  This is where I was experiencing instability issues before, with the software hanging and occasionally crashing when I was inserting functions into the reports.  I have yet to get to this stage but experienced an issue when attempting to insert a formula into the report using the wizard.
This is a very simple formula:
if(isblank([date of termination]);"Still Active";[date of termination])

When attempting to insert this using the wizard, the system would consistently hang, but I was successfully able to directly enter the formula, and it worked without any issues.
My next step is to insert some functions into the report and see if there are any issues with this.
It appears at this stage that the issues are not related to the database i.e. the issue may appear when using either postgresql or hsqldb, but lies somewhere in the installation of Libreoffice.
 
Version: 7.0.1.2
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 2; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded
OS: Linux Mint 19.2

(In reply to Michael Manning from comment #5)

> This is a very simple formula:
> if(isblank([date of termination]);"Still Active";[date of termination])

Try to set it like this:

if(isblank(["date of termination"]);"Still Active";["date of termination"])

You got an error in QuotedFunctionName. Fields must be set in square brackets, Fields with special characters and spaces must be set with double quotes and square brackets.

Many thanks.  I will edit the formula and bear this in mind for all formulas and functions.

I this this can now be closed.

cheers

Mike

(In reply to Michael Manning from comment #7)
> 
> I this can now be closed.

Closed this one as WORKSFORME.