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.
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.
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.