| Report with Columns [message #79976] |
Tue, 30 July 2002 14:55  |
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  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
