Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Part of Report TTITLE code, keep page numbering

Status
Not open for further replies.

sxschech

Technical User
Jul 11, 2002
1,033
US
How would I change a part of the title and still keep the page numbering going? In the example below, I would like to have the 3rd line display different text. I am running this out of a script that has several query blocks. The only part that needs to be changed when there is a new query is the last line of the TTITLE.

Code:
BREAK ON TODAY

COLUMN TODAY   NOPRINT NEW_VALUE DATEVAR
COLUMN CURTIME NOPRINT NEW_VALUE TIMEVAR

SELECT TO_CHAR(SYSDATE,'MM/DD/YY') today, TO_CHAR(SYSDATE,'HH:MM:SS') curtime FROM DUAL;

CLEAR BREAKS


TTITLE LEFT 'DATE RUN   ' datevar '                                University of STA CALIFORNIA                             REPORT PAGE  ' FORMAT 999 SQL.PNO  SKIP 1 -
       LEFT 'TIME RUN   ' timevar '                             Reports Information System - ABCD                          PROGRAM ID RPT021'                 SKIP 3 -
       LEFT 'Condensed Applicant Totals Report' 												       SKIP 2

On a subsquent page, I would like

LEFT 'Condensed Applicant Totals Report'

to say

LEFT 'Out of State Applicant Totals Report'

however, if this is on page 3, I would still like the report to say page 3 and not revert to page 1.
 
As a follow on to the above, if there is a new query within the same page (still space on the page for more data before a page break), how would I display only the

LEFT 'Condensed Applicant Totals Report'

without showing the page header information.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top