Home » SQL & PL/SQL » SQL & PL/SQL » Formatting 3 Column Report
Formatting 3 Column Report [message #6756] Mon, 05 May 2003 06:15 Go to next message
Rudy
Messages: 12
Registered: March 2002
Junior Member
Create a 3 column report and needing assistance on how to center all the report in the middle of the page.

TTITLE "SALARY REPORT"
SELECT LASTNAME, FIRSTNAME, SALARY
FROM EMPLOYEE, SALARY
WHERE EMPLOYEE.ID_NUM = SALARY.ID_NUM

Any help would be appreciated.

Rudy

Report message to a moderator

Re: Formatting 3 Column Report [message #6771 is a reply to message #6756] Tue, 06 May 2003 00:07 Go to previous messageGo to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
Use this:

Set Linesize 132
(Used to set number of characters in a line, set the linesize according to ur requirement. I m not sure whether it works. Just try & let me know the result.)

Report message to a moderator

Re: Formatting 3 Column Report [message #6773 is a reply to message #6756] Tue, 06 May 2003 00:16 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
Senior Member
To center the title:

TTITLE CENTER "SALARY REPORT"

Report message to a moderator

Re: Formatting 3 Column Report [message #6795 is a reply to message #6756] Tue, 06 May 2003 12:56 Go to previous message
anam
Messages: 14
Registered: December 2002
Junior Member
u can justify the the column left,ridht or center by using JUSTIFY {LEFT&#124RIGHT&#124CENTER} with COLUMN command.
eg
COLUMN SALARY JUSTIFY CENTER FORMAT $99,999.00

Report message to a moderator

Previous Topic: Using a boolean in a stored function
Next Topic: UPDATE/INSERT data in Oracle Form
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 22:54:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.