New Page/Break on commands [message #280175] |
Mon, 12 November 2007 12:56 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
adrianbiccum
Messages: 9 Registered: October 2007
|
Junior Member |
|
|
Hi All,
We're trying to format a report where the report breaks on a new page, physically, when a column has a new value...
We set the Newpage to 0, but it always prints a blank page before the report and in between all the pages until it gets to the new column value then it prints to a new page.
Has anyone ever run into this? How did resolve it?
Thanks!
AB
|
|
|
|
Re: New Page/Break on commands [message #280181 is a reply to message #280175] |
Mon, 12 November 2007 13:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
adrianbiccum
Messages: 9 Registered: October 2007
|
Junior Member |
|
|
Sorry, I should have specified that we already have that line in our report...
Break on <column> skip page
It's working to a degree, what we'd like to get rid of are those extra blank pages we're getting when we run the report.
??
Thanks AB
|
|
|
|
Re: New Page/Break on commands [message #280228 is a reply to message #280183] |
Mon, 12 November 2007 20:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
rleishman
Messages: 3728 Registered: October 2005 Location: Melbourne, Australia
|
Senior Member |
|
|
You can't avoid the first one, but setting
orwill help with the intermediate breaks.
Note that you never get intermediate page breaks with PAGESIZE 0, but nor do you get column headings.
Ross Leishman
|
|
|