Le 04/04/2013 11:16, Marion & Noel Lodge a écrit :
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?
Not that I know of. One of the feature limitations of the ORB I guess.
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?
assign a macro that checks your result set for NULL and then replaces
that in the report by a space char, or rewrite the query that you use to
fetch the value and CAST it as another data type.
Another idea, off the cuff, but untested - deactivate automatic number
recognition in your table (if the report is a Writer document) or else
globally (I think there is a setting somewhere in Options ?)
One final question - is there a better alternative to Oracle Report
Yes, but all of them require manual/semi-automated fiddling with ODF
documents, or programming knowledge, or both.
For unsubscribe instructions e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy