sqlplus/newpage/formfeed problem

From: Kristin Schrenk <kschrenk_at_americantv.com>
Date: 16 Jun 1998 22:04:38 GMT
Message-ID: <01bd9972$c09c6b80$e80a6994_at_isprg2>



My question is about the formatting of a report in sqlplus and how to control when a formfeed is printed in the output.

We tend to use the following setup:

set pagesize 58
set newpage 0

We do this so we can print 58 lines and then a form feed, allowing for varying pagesize between printers. Newpage prints a formfeed at the beginning of each page including the first. Logically, I would think we would want a formfeed at the end of each page(?).

The problem we run into is we keep getting a blank page printed out at the start of each report. Does anyone know of a way around this. Ideally we would want a "newpage" option that does not put in the top formfeed.

In the past we had gotten around this by putting in filter in the print services to remove the leading form feed before printing the output, but this is kind of a goofy way to do it. We switched print services and lost this fix, that is how we ran across the problem again. We will probably put the little fix back if we do not come up with a better idea for actually fixing the sqlplus.

Any ideas? Received on Wed Jun 17 1998 - 00:04:38 CEST

Original text of this message