I am trying to create a Report in LO 220.127.116.11 with multiple 2 line Label fields.
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.