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

Thanks Girvin

You were the only one to come back to my question!!

The report layout looks fine, (FieldNames in the 'Header' and the field's data in the 'Detail'), but no matter what I do it displays alternative rows of Headings and Data!!

I have however, in the absence of any other suggestions, come up with a work-round ...

1) Call up the Query the Report runs on.
2) Select everything. (Click top-left corner)
3) Copy everything. (Right-click and select 'copy')
4) Open a new Text Document and Paste, (A box comes up to select which fields you want). (*BTW* - This display is exactly the way it used to be and the way I want it.
    ie one line of Headings and all the Data below!!)
5) Click inside the new Table and select Table>Convert>Table to Text.
6) Remove the Headings line.


I still wonder however why this was changed and what the "proper" answer is!!!!????

Regarding my SQL problem - I could not get the old string to work at all but after a little digging I got YOUR 'CONCAT' string to work for me. I guess this must be a difference between HSQL and MySQL!! Thanks for this!!!

As always I greatly appreciate the assistance!!

Pretoria RSA

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.