Re: [libreoffice-users] LO Base Reports

Ian Whitfield wrote:
> 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??
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
>
> IanW
> Pretoria RSA.
Hope this helps.
Girvin Herr


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