[libreoffice-users] LO Base Reports

Hi All

Since I upgraded to LO 3.6.2.2 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??

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)

Can someone please put me right!!

Thanks a lot

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