Home » Developer & Programmer » Forms » Report with Columns
Report with Columns [message #79976] Tue, 30 July 2002 14:55 Go to next message
Franklin
Messages: 4
Registered: July 2002
Junior Member
How can I create a report with columns? I have results from a query that will spread onto 2 pages,but only contains 3 columns of data so I would like 1-50 in the first column and 51-100 in the second column so it all fits on the same page.
Can anyone point me in the right direction?
Re: Report with Columns [message #79998 is a reply to message #79976] Thu, 01 August 2002 03:14 Go to previous messageGo to next message
Zoran Peca
Messages: 10
Registered: May 2002
Junior Member
Hi Franklin,

I guess that you are running those queries from SQL*PLUS. In that case use for both columns command:
COL column_name FORMAT A50 (50 is for 50 chars length)
The same is with columns which contains numbers. Instead of Axx put the number format, eg. 999, 999.99 etc.
You can find this in Oracle Documentation for SQL*Plus.

Best Regards,

Zoran
Re: Report with Columns [message #80006 is a reply to message #79976] Thu, 01 August 2002 22:28 Go to previous message
Zoran Peca
Messages: 10
Registered: May 2002
Junior Member
Hi Franklin,

In that case frstly you should set Report Module property Design in Character Units on Yes. Then you find the Repeating Frame in which those data are showed and set its property Horizontal Elasticity on Fixed. The third thing is that you shoud switch the Report Editor to the Layout Model and there carefuly strech all frames that surround your data fields. Now you can resize your data fields on 50 chars, or whichever size you want.

Regards,

Zoran
Previous Topic: is dropping column supported in 814 db
Next Topic: Re: Developer Form6/Form6i Proble.
Goto Forum:
  


Current Time: Tue Nov 30 12:42:41 CST 2021