How 2 create a report either with 2 line Label field or no Label field

Hello All,

I am trying to create a Report in LO with multiple 2 line Label fields.
Something like:
Water | Fresh
L’eau | Potable

I am using a DataBase Query in a Split DataBase HSQL 2.5.1, to create resultsets, based on input by the User.
So far I have not found anything in HSQL that allows me to do that.

If there is no solution, then my next question is:
Is there a way to create a resultset in HSQL without a header at all?

I have to import the resultset in an external DataBase (likely an MS database), not under my control.

There is a template in xlsx-format available for import into the external DataBase.
So, either I am able to re-create the template with data from the DataBase, or I use the Query as a Source for the existing template, but that means no header.

Any suggestions?


Multi line was a problem in the later 6.x series. It is now fixed & better in 7.0.x releases. Just tested report labels with v7.0.4.2