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