OraFAQ Forum: Reports & Discoverer » My report has 43 columns

Home » Developer & Programmer » Reports & Discoverer » My report has 43 columns

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

My report has 43 columns [message #269054]

Thu, 20 September 2007 10:33

Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA

Senior Member

I am in the process of building an oracle report and it has 43 columns. What is the highest size for an oracle report to go? Like 180 by 60 or 340 by 70 or something...Let me know. I believe these columns will wrap and not fit. Any advice to make all the columns fit? No, I can't get rid of any columns...need them all.

Anne

Report message to a moderator

Re: My report has 43 columns [message #269057 is a reply to message #269054]

Thu, 20 September 2007 10:42

Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata

Senior Member

The highest width and height of oracle reports 10g is 9,999 character.

Cheers
Soumen

Report message to a moderator

Re: My report has 43 columns [message #269082 is a reply to message #269057]

Thu, 20 September 2007 12:22

Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA

Senior Member

What about 6i Oracle Reports?

Anne

Report message to a moderator

Re: My report has 43 columns [message #269098 is a reply to message #269082]

Thu, 20 September 2007 12:41

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

Any advice to make all the columns fit?

Use smaller font.

Report message to a moderator

Re: My report has 43 columns [message #269101 is a reply to message #269054]

Thu, 20 September 2007 12:47

hv0435@gmail.com
Messages: 3
Registered: August 2007

Junior Member

If you have so many columns to display ..better display the output in an excel sheet. You can set the generate to file option as delimited file and see the results in a excel sheet.

Report message to a moderator

Previous Topic:	Restrict number of pages
Next Topic:	How to use Formula column in Oracle Reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 15 15:22:16 CST 2026