Home » Developer & Programmer » Reports & Discoverer » Oracle reports 9i text cut horizontally and the same text is printed on itself (Oracle reports 9i )
| Oracle reports 9i text cut horizontally and the same text is printed on itself [message #613020] |
Mon, 28 April 2014 23:23  |
 |
fatih1000
Messages: 8
Registered: April 2014
|
Junior Member |
|
|
Hello,
I have a problem regarding oracle reports 9i. First, there are a number of boilerplate texts in the report. All the data and parameteres are passed through oracle forms, nothing is retrieved from database.
When I run a report I see that some of the boilerplate texts started printing on one physical page and continued on the next page and they are cut horizontally, so that it is sometimes unreadable. Is there a way to handle this?
Margin couldn't help, I tried frames, anchors and I even put everything in just one text, the result is the same. The vertical elasticity was expand or variable, didn't matter.
Second, the same texts (started printing on one physical page and continued on the next page) are printed on itself (printed twice), so there are two text on almost at the same place, it also becomes unreadable. So there two problems that I couldn't solve.
Please help me with your suggestions, thank you.
|
|
|
|
| Re: Oracle reports 9i text cut horizontally and the same text is printed on itself [message #613022 is a reply to message #613020] |
Tue, 29 April 2014 00:08  |
 |
Littlefoot
Messages: 21759
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Cut text: as you pass it from a form, how do you do that? Is it by using a global variable? Whatever it is, make sure that all the text fits into its carrier (whether it is a global variable or not). If text is too large, maybe you'll have to use two (or more) variables and concatenate them. In that case, don't create fields in report's layout - use "&" notation instead, such asThis is &variable_1 &variable_2
Consider creating a table; you'd store all data into that table and let report fetch from it. You can even remove its contents (either from a report - its After Report trigger, or from a form.
Text printed twice: what kind of a layout is that? As texts "almost" fit, it means that there must be two fields (possibly in two different frames) which aren't aligned horizontally and/or vertically (because, if they were, you wouldn't even notice that there are two texts). I thought that the reason might be a repeating frame which prints the same field twice, but you'd then see texts one below the other (or side by side, depending on print direction).
I don't have any other ideas at the moment.
|
|
|
|
|
|
| Re: Oracle reports 9i text cut horizontally and the same text is printed on itself [message #613033 is a reply to message #613028] |
Tue, 29 April 2014 01:05 |
|
Littlefoot
Messages: 21759
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
"Hello this is oracle forum &oracle, welcome."
That's what I thought, yes. What is ORACLE, exactly? Its size? Is it capable of holding the whole text? You could find it out by selecting its length in both form and report (in a form, before sending ORACLE to report, display its size asmessage('ORACLE length = ' || length(:oracle));
About concatenation: if you have to pass ORACLE split in two pieces (so that you'd pass ORACLE_1 and ORACLE_2, you'd display ""Hello this is oracle forum &oracle_1 &oracle_2, welcome." in a report.
If you store data into a table, I think that you can't format it (i.e. put something into bold, italic, whatever) so the same "unformatted" text would be displayed in a report. If formatting IS possible, I don't know how to do it.
As of duplicate text: so, there aren't two items nor two frames? Is there any anchor there, perhaps?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sat Mar 25 08:32:36 CDT 2023
|
] 
Search
Help
Members
Register
Login
Home
