Re: SQL*Plus break header

From: Frank <fbortel_at_home.nl>
Date: Tue, 11 Nov 2003 22:42:22 +0100
Message-ID: <borkkt$flg$1_at_news2.tilbu1.nb.home.nl>

Phil Bewig wrote:

> sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0311110136.73ef31a_at_posting.google.com>...
> 

>>pbewig_at_swbell.net (Phil Bewig) wrote in message news:<455f7154.0311101753.1a54a17b@posting.google.com>...
>>
>>>Frank <fbortel_at_home.nl> wrote in message news:<booukh$ll8$1_at_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

Received on Tue Nov 11 2003 - 22:42:22 CET