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 lodg...@gmail.com On 6 April 2013 05:26, Girvin R. Herr 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//.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 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 ReferenceAmount 01/01/2013 Dick Smith - 3.5mm Plug &14.94, 25 CD 1363649.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-h
Re: [libreoffice-users] Oracle Report Builder - Text field overflow and N.aN problem
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//.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 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 ReferenceAmount 01/01/2013 Dick Smith - 3.5mm Plug &14.94, 25 CD 1363649.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
Re: [libreoffice-users] Oracle Report Builder - Text field overflow and N.aN problem
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 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 >> ReferenceAmount >> 01/01/2013 Dick Smith - 3.5mm Plug &14.94, 25 CD >> 1363649.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
Re: [libreoffice-users] Oracle Report Builder - Text field overflow and N.aN problem
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 ReferenceAmount 01/01/2013 Dick Smith - 3.5mm Plug &14.94, 25 CD 1363649.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
[libreoffice-users] Oracle Report Builder - Text field overflow and N.aN problem
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 ReferenceAmount 01/01/2013 Dick Smith - 3.5mm Plug &14.94, 25 CD 1363649.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 -- 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