Home » Developer & Programmer » Reports & Discoverer » Report Formatting (Oracle Report Builder 10g, Windows XP)
icon5.gif  Report Formatting [message #479931] Wed, 20 October 2010 05:23 Go to next message
dipayansilbtcom
Messages: 2
Registered: October 2010
Junior Member
Hi,

I have developed one report but need one formatting suggestion.
There is one field called "DESCRIPTION", I want the value of this field to be displayed in a single line. Now the big values are wrapped into multiple line.

Now,

DISPLAY
----------------
This is a Oracle
Report.

I want,
DISPLAY
------------------------
This is a Oracle Report.

Maxium size of "DISPLAY" field is VARCHAR2(240).
Please suggest.
  • Attachment: BTACCANL.rdf
    (Size: 676.00KB, Downloaded 1306 times)

Report message to a moderator

Re: Report Formatting [message #479932 is a reply to message #479931] Wed, 20 October 2010 05:32 Go to previous messageGo to next message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
1) Move the field down a line. So each record in that section will take two lines rather than one.
2) Use a smaller font.

Report message to a moderator

Re: Report Formatting [message #479936 is a reply to message #479932] Wed, 20 October 2010 05:54 Go to previous messageGo to next message
dipayansilbtcom
Messages: 2
Registered: October 2010
Junior Member
It is not working. I want the value of display in a single line. Also I am using font size 9, which is minimal. Checked with font size 8, but without any luck.

For my own investigation I have changed one property of the "DISPLAY" field, Horizontal Elasticity to Expand. It is too not working.

Report message to a moderator

Re: Report Formatting [message #479939 is a reply to message #479936] Wed, 20 October 2010 06:08 Go to previous message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
Where exactly do you expect the field to expand to? If it gets wider it'll just overlap the next field. You've run out of space horizontally.
Here's some other options:
1) Make the report landscape instead of portrait.
2) Remove some fields.
3) Truncate some fields (use substr).

If you can do 1 then that'd be best. Next best would be my first suggestion in the previous post.

Report message to a moderator

Previous Topic: rep 3300 / ui 1238540 (merged)
Next Topic: UNABLE TO RUN THE SQL IN REPORT 3.0
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 09:06:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.