Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Ian Whitfield wrote:
Hi All

Since I upgraded to LO on my PCLOS 2012 system I find that Base no longer displays my Reports the way I need them!!

I used to get a single line of 'Field Names' followed my multiple lines of data.

What I get now is alternating lines of 'Field Names' and one row of data. (I've tried all the options given and they all do this!!)

How can I get back to my original layout??
I don't know how or why your report got changed, but you should be able to drag the fields back to where you want them in the report editor. It sounds like your field names are now located in the detail section rather than the heading section. You don't say what version you upgraded from, but lately, LO is bundling the Oracle Report Builder extension, which may have changed something if you weren't using it before the upgrade.

Second problem - I have a need to produce a file, with the data in the format "Field_One|Field_Two". I was given the SQL Command of "PrefFirstName" || '|' || "Email" but failed to make a note of how I set this up in the Report.
(All I get now is a syntax error - whatever I try)

Have you looked at using the MySQL CONCAT_WS function in a query? This function allows you to concatenate fields, and specify a field delimiter string, into a single line of text. For example:

   CONCAT_WS('|',` Field_One`,`Field_Two`)

should result in the format you specified. In my case, I am using it in a SELECT clause to format my supplier data inside a form listbox. It displays the name, address, etc, separated by ' | ' strings so the fields are not all run together. It isn't fixed columns, but it works well enough for me.
Can someone please put me right!!

Thanks a lot

Pretoria RSA.

Hope this helps.
Girvin Herr

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.