Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!rip!news.webusenet.com!peer01.cox.net!cox.net!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!skynet.be!skynet.be!newshub1.home.nl!home.nl!not-for-mail
From: Frank <fbortel@home.nl>
Newsgroups: comp.databases.oracle.tools
Subject: Re: SQL*Plus break header
Date: Tue, 11 Nov 2003 22:42:22 +0100
Organization: @Home Benelux
Lines: 44
Message-ID: <borkkt$flg$1@news2.tilbu1.nb.home.nl>
References: <455f7154.0311101302.310abb98@posting.google.com> <booukh$ll8$1@news4.tilbu1.nb.home.nl> <455f7154.0311101753.1a54a17b@posting.google.com> <a1d154f4.0311110136.73ef31a@posting.google.com> <455f7154.0311110626.ba967e0@posting.google.com>
Reply-To: fbortel@nescape.net
NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news2.tilbu1.nb.home.nl 1068586462 16048 217.121.193.81 (11 Nov 2003 21:34:22 GMT)
X-Complaints-To: abuse@home.nl
NNTP-Posting-Date: Tue, 11 Nov 2003 21:34:22 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
In-Reply-To: <455f7154.0311110626.ba967e0@posting.google.com>
Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:83495

Phil Bewig wrote:

> sybrandb@yahoo.com wrote in message news:<a1d154f4.0311110136.73ef31a@posting.google.com>...
> 
>>pbewig@swbell.net (Phil Bewig) wrote in message news:<455f7154.0311101753.1a54a17b@posting.google.com>...
>>
>>>Frank <fbortel@home.nl> wrote in message news:<booukh$ll8$1@news4.tilbu1.nb.home.nl>...
>>>
>>>>Phil Bewig wrote:
>>>>
>>>>
>>>>>I am using SQL*Plus and ordinary SQL (no PL/SQL) to create a
>>>>>report.  I would like to write a header line each time a field
>>>>>breaks:
>>>>
>>>>Something like 'new value' pops to mind
>>
>>The new_value solution typically comes into play when you want to use
>>the column value in a title. Otherwise it isn't of much use.
>>To avoid repeating you simply need to use the nodup(licates) clause of
>>the break command.
>>If you want to use the value in a title you need to have
>>
>>column bar new_value _bar noprint
>>ttitle "current value of bar is &_bar" center skip 2
>>break on bar skip page nodup
>>select bar, <whatever you want> 
>>from foo
>>/
> 
> 
> I know about master/detail reports that put the break field in the
> ttitle.  However, I have many small accounts, and don't want to start
> a new page for each one.
> 
> Thanks again to all who have responded, and thanks in advance for any
> additional help you can provide.
> 
> Phil
Then don't skip page, but skip 2 (or 3, or just 1 and a dashed line)

-- 
Regards, Frank van Bortel