SQLPLUS - Disable second page break on two consecutive page breaks
Date: 21 May 92 06:55:02 GMT
Message-ID: <1992May21.065502.22112_at_cmutual.com.au>
Subject: SQLPLUS - Disable second page break on two consecutive page breaks
I have a problem in producing a report with page breaks on two columns. The problem is that having a page break on the second column causes the total for the first item to be produced on a new page rather than under the last total for the second column.
Can anyone suggest a solution to my problem ? This is an example of the problem :
> COMPUTE SUM OF AMOUNT ON FUND CURRENCY;
> BREAK ON FUND SKIP PAGE ON CURRENCY SKIP PAGE;
> SELECT FUND,CURRENCY,AMOUNT FROM TABLE ORDER BY FUND,CURRENCY;
FUND CURRENCY AMOUNT ----- --------- ------- 01 AUD 1000 2000 *** ------- sum 3000
_at_@@ new page here
FUND CURRENCY AMOUNT ----- --------- ------- USD 1000 1000 *** ------- sum 2000 <---- I AM TRYING TO DISABLE THIS PAGE _at_@@ new page here <---- BREAK SO THE FUND TOTAL IS UNDER <---- THE LAST CURRENCY TOTAL FOR THE <---- FUND FUND CURRENCY AMOUNT ----- --------- ------- ***** ------- sum 5000
_at_@@ new page here
FUND CURRENCY AMOUNT ----- --------- ------- 02 AUD 1000 2000 *** ------- sum 3000
_at_@@ new page here
FUND CURRENCY AMOUNT ----- --------- ------- ***** ------- sum 3000
This is the format I am after :
FUND CURRENCY AMOUNT
----- --------- -------
01 AUD 1000
2000
*** -------
sum 3000
_at_@@ new page here
FUND CURRENCY AMOUNT
----- --------- -------
USD 1000
1000
*** -------
sum 2000
***** -------
sum 5000 <---- NOTE NO PAGE BREAK HERE
_at_@@ new page here
FUND CURRENCY AMOUNT
----- --------- -------
02 AUD 1000
2000
*** -------
sum 3000
***** -------
sum 3000
Please email to the newsgroup or directly to me.
-- John Moran email: JMoran_at_cmutual.com.au Systems Analyst Programmer. phone: +61-3-6076584 Colonial Mutual Life Aust. (ACN 004021809) fax : +61-3-6076198Received on Thu May 21 1992 - 08:55:02 CEST