Re: [libreoffice-users] LO Base Reports

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.

Viola!!!

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!!

Ianw
Pretoria RSA



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted