SQL*PLUS report footer [message #442635] |
Tue, 09 February 2010 10:54  |
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  |
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
|
|
|