OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Report Formatting (Oracle Report Builder 10g, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Report Formatting [message #479931]

Wed, 20 October 2010 05:23

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 1538 times)

Report message to a moderator

Re: Report Formatting [message #479932 is a reply to message #479931]

Wed, 20 October 2010 05:32

cookiemonster
Messages: 13960
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

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

cookiemonster
Messages: 13960
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 10:09:57 CST 2024