Formatting query results

From: Martin <I.want_at_no.mail>
Date: 13 Jan 1999 16:40:20 GMT
Message-ID: <77ii9k$kfr$1@hdxf08.telecom.ptt.nl>

Hi all,

I'm trying to format the following query:

SET HEADING ON
SET PAGESIZE 10000
CLEAR BREAKS
COLUMN MAAND FORMAT A9
COLUMN JAAR FORMAT A4
COLUMN MAANDNR NOPRINT
COLUMN NET FORMAT A4
BREAK ON JAAR SKIP 2 NODUP
BREAK ON NET SKIP 1 NODUP <---- This is no use :-(

SELECT TO_CHAR(VKV_TELDATUM, 'YYYY') JAAR

      ,VKV_NET_VAN NET
      ,TO_CHAR(VKV_TELDATUM, 'MONTH') MAAND
      ,TO_CHAR(VKV_TELDATUM, 'MM') MAANDNR
      ,COUNT(*) AANTAL

FROM BAAS_VERKEER
GROUP BY TO_CHAR(VKV_TELDATUM, 'YYYY')

        ,VKV_NET_VAN
        ,TO_CHAR(VKV_TELDATUM, 'YYYY')
        ,TO_CHAR(VKV_TELDATUM, 'MM')
        ,TO_CHAR(VKV_TELDATUM, 'MONTH');

I get this:

1997 AAAA JANUARY         1116
     AAAA FEBRUARY         771


     .


     . 


     AAAB JANUARY           45
     AAAB FEBRUARY          46


     .


     .



     etc


1998 AAAA JANUARY         1116
     AAAA FEBRUARY         771


     .


     . 


     AAAB JANUARY           45
     AAAB FEBRUARY          46


     .


     .



     etc

But I want this:

1997 AAAA JANUARY         1116
          FEBRUARY         771


     .


     . 


     AAAB JANUARY           45
          FEBRUARY          46


     .


     .



     etc


1998 AAAA JANUARY         1116
          FEBRUARY         771


     .


     . 


     AAAB JANUARY           45
          FEBRUARY          46


     .


     .



     etc

I understand only one break can be defined at one time, but is there a way to get the layout I want ? (with or without breaks).

TIA, Martin Received on Wed Jan 13 1999 - 10:40:20 CST