Oracle Report Builder - Text field overflow and a N.aN problem

users
#1

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.

  01/01/2013

  Dick Smith - 3.5mm Plug $14.94, 25 CD

  13636

  -49.92

  Dr

  01/01/2013

  Cases $9.98, HeadPhones $25.00

  N.aN

  Dr

#2

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.

<snip>

--
Noel Lodge
lodgemn@gmail.com

Are you using "Oracle Report Builder" or the included "Report Builder" extension? Which version of LO are you using, and which OS and version of "Oracle Report Builder" are you using? It would be helpful to know these things for the people here that know that type of package inside and out.

Are we still using "Oracle Report Builder" for the extension, or did someone modify it for TDF/LO and changed the name to "Report Builder"? I know that "Report Builder" not "Oracle. . ." is a installed and locked extension that has been a part of LO installs for months now.

#3

Kracked_P_P---webmaster wrote:

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.

<snip>

--
Noel Lodge
lodgemn@gmail.com

Are you using "Oracle Report Builder" or the included "Report Builder" extension? Which version of LO are you using, and which OS and version of "Oracle Report Builder" are you using? It would be helpful to know these things for the people here that know that type of package inside and out.

Are we still using "Oracle Report Builder" for the extension, or did someone modify it for TDF/LO and changed the name to "Report Builder"? I know that "Report Builder" not "Oracle. . ." is a installed and locked extension that has been a part of LO installs for months now.

I just checked and the Apache Open Office extensions site is still calling it Oracle Report Builder, version 1.2.1.
I also checked my LibreOffice 3.6.4.3 "extension" (built-in) and it is just called "Report Builder" version 1.2.3. So, it appears some modification to the ORB 1.2.1 has been made to the LO bundled Report Builder. Maybe I should try it again...
Girvin Herr

#4

Hi all,

I just checked and the Apache Open Office extensions site is still
calling it Oracle Report Builder, version 1.2.1.
I also checked my LibreOffice 3.6.4.3 "extension" (built-in) and it is
just called "Report Builder" version 1.2.3. So, it appears some
modification to the ORB 1.2.1 has been made to the LO bundled Report
Builder. Maybe I should try it again...

The version number was bumped up a notch in LO to avoid conflict with the Apache ORB extension so that users could in theory install both, and also to reflect some name changes in API service implementations within the LO code. The actual ORB code used in LO has not changed significantly as far as I know.

Alex

#5

Alex Thurgood wrote:

Hi all,

I just checked and the Apache Open Office extensions site is still
calling it Oracle Report Builder, version 1.2.1.
I also checked my LibreOffice 3.6.4.3 "extension" (built-in) and it is
just called "Report Builder" version 1.2.3. So, it appears some
modification to the ORB 1.2.1 has been made to the LO bundled Report
Builder. Maybe I should try it again...

The version number was bumped up a notch in LO to avoid conflict with the Apache ORB extension so that users could in theory install both, and also to reflect some name changes in API service implementations within the LO code. The actual ORB code used in LO has not changed significantly as far as I know.

Alex

Alex,
Thanks for saving me from wasting my time.
Girvin Herr

#6

Have you tried Oracle report builder
<http://www.devart.com/dbforge/oracle/studio/oracle-report-designer.html>
in dbForge Studio for Oracle? This perfect IDE solves almost all the task of
database development and management! Generating reports is only one of its
multiple features! You can read more about this software here:
http://www.devart.com/dbforge/oracle/studio/