Home » SQL & PL/SQL » Client Tools » SQL*PLUS report footer (SQL*PLUS 10.1.2.3, linux)
SQL*PLUS report footer [message #442635] Tue, 09 February 2010 10:54 Go to next message
dlwixon
Messages: 92
Registered: September 2008
Member
I am trying to put a report footer on a report that has a title.

However, when I specify the REPFOOTER under the title specification, I get the text after every row in the report.

If I put it before the TTITLE definition, I get the TTITLE text before and after the report and the REPFOOTER text after the report.

How do I get the TTITLE to appear only before the report and the REPFOOTER text to appear only after the same report?

For example, if I specify
REPFOOTER 'footer text'
TTITLE 'title text'

the above text prints the TTITLE text before and after the report. and the REPFOOTER text after the report.

Is there a way to only have the TTITLE text come before the report and the REPFOOTER text after?

[Updated on: Tue, 09 February 2010 11:37]

Report message to a moderator

Re: SQL*PLUS report footer [message #442650 is a reply to message #442635] Tue, 09 February 2010 13:59 Go to previous message
dlwixon
Messages: 92
Registered: September 2008
Member
It can be done.

I had a hyphen after my last TTITLE line that was messing it up. I took that out and it worked.

So here is what works:

TTITLE CENTER 'First line of title text' SKIP 1 -
CENTER 'Second line of title text' SKIP 2 -
CENTER 'Third line of title text' SKIP 1 -
CENTER 'Last line of title text' 
REPFOOTER CENTER 'Footer text'


Works great!

[Updated on: Tue, 09 February 2010 14:00]

Report message to a moderator

Previous Topic: Oracle issue after install ODBC
Next Topic: Toad error
Goto Forum:
  


Current Time: Mon Dec 05 02:54:15 CST 2016

Total time taken to generate the page: 0.13099 seconds