Re: [libreoffice-users] Oracle Report Builder - Text field overflow and N.aN problem

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
lodgemn@gmail.com


On 6 April 2013 05:26, Girvin R. Herr <girvin.herr@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
> > lodgemn@gmail.com
> >
> >
> > On 5 April 2013 10:54, Girvin R. Herr <girvin.herr@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
> > > > lodgemn@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+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