Hi Girvin, Thanks for all that information . When I get time, I'll disable Oracle Report Builder and try LO 3.6 again. Hopefully I will then get Report Builder 1.2.3 and see if that solves my problem with N.aN.
Noel -- Noel Lodge lodg...@gmail.com On 6 April 2013 05:26, Girvin R. Herr <girvin.h...@sbcglobal.net> wrote: > Noel, > I don't think you should have a problem between 3.5 and 3.6 installation. > The files, at least on my Linux machine, are in separate directories. LO > 3.5 is in libreoffice3.5, LO 3.6 is in libreoffice3.6, and even openoffice > 3.x is in openoffice.org3. So, these versions should co-exist on the same > computer without conflict. There has been much discussion about this very > subject in past postings on this forum. > > However, the same is not true for your personal configuration (options, > etc.). On my Linux machine, the configuration files are in > /home/<user>/.config/**libreoffice/3. So, both 3.5 and 3.6 will use the > same configuration directory. User-installed extensions seem to be > registered in this directory also. So, the bottom line is that you may > indeed have to uninstall your ORB extension prior to installing LO 3.6, if > only just to ensure a clean start on 3.6. Alternately, you could rename > this directory to something else temporarily, such as 3.5. That way, if > 3.6 doesn't gain you anything, you can always go back to 3.5 by renaming > the directory back to 3 again. (Make sure LO is not running when you do > this.) > > Someone else in this forum may be able to specify exactly when Report > Builder was first bundled into LibreOfiice, but I first noticed it around > 3.5.3. > Hope this helps. > Girvin Herr > > > > Marion & Noel Lodge wrote: > >> Thanks for the replies. I'm away for the next couple of days, so I won't >> be >> able to try the suggestions till I get back. >> >> I take it that Report Builder is part of the download of LO 3.6.5, (which >> I >> tried a while ago but ran into problems that I didn't have time to >> investigate fully, so I went back to LO 3.5.6.2). If I try LO 3.6.5, >> should I remove Oracle Report Builder 1.2.1 before installing 3.6.5? >> >> I'm running Windows 7 64 Bit. >> >> Thanks, >> >> Noel >> -- >> Noel Lodge >> lodg...@gmail.com >> >> >> On 5 April 2013 10:54, Girvin R. Herr <girvin.h...@sbcglobal.net> wrote: >> >> >> >>> Marion & Noel Lodge wrote: >>> >>> >>> >>>> Sorry about my previous post. Hit the wrong button and sent it >>>> prematurely! >>>> >>>> With Oracle Report Builder it does not seem to be possible to have a >>>> text >>>> field overflow into the next line and push everything below that down a >>>> line. (I'm porting an application from an old Paradox system and this >>>> was >>>> possible in Paradox reports.) If I make the text box double height in >>>> Report Builder, then the second line appears OK, but most of the records >>>> don't need a second line and end up being double spaced. Is there any >>>> work >>>> around for this? >>>> >>>> What I have tried is to use a macro to check the length of each text >>>> string >>>> , >>>> and if it exceeds 40 characters then I create a second record to contain >>>> the excess characters. >>>> I've almost got it working as shown below - >>>> >>>> >>>> Date Details >>>> Reference Amount >>>> 01/01/2013 Dick Smith - 3.5mm Plug &14.94, 25 CD >>>> 13636 49.92 Dr >>>> Cases $9.98, Headphones $25.00 >>>> N.aN Dr >>>> The problem is the N.aN in the amount column. In the Table this field >>>> is >>>> blank, but Report Builder displays it as N.aN which I understand means >>>> 'Not >>>> a Number'. I want it to be blank in the Report. I've tried all sort of >>>> possibilities in Conditional Print in the General Tab for that field, >>>> but >>>> nothing seems to work. Has anyone found a solution to this problem? >>>> >>>> One final question - is there a better alternative to Oracle Report >>>> Builder? >>>> >>>> >>>> I am running LibreOffice 3.5.6.2, Oracle Report Builder 1.2.1 and >>>> Windows >>>> 7 64 Bit >>>> >>>> Thanks, >>>> >>>> Noel >>>> -- >>>> Noel Lodge >>>> lodg...@gmail.com >>>> >>>> >>>> >>>> >>>> >>> I am running LO 3.6.4.3 (Linux) and it has "Report Builder" version 1.2.3 >>> bundled in. So something has been changed. You might try that upgrade. >>> Note that "Oracle Report Builder" is a term that Apache Open Office still >>> uses for their report builder extension. However, LibreOffice uses just >>> "Report Builder" when referring to their bundled report builder >>> extension. >>> So your use of the ORB term is confusing, since theoretically you could >>> install the Oracle Report Builder over top of the LO-bundled Report >>> Builder. You need to inform this forum just which RB you are using. >>> Girvin Herr >>> >>> >>> >>> >>> >> >> >> > -- For unsubscribe instructions e-mail to: users+h...@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