Hello to all,
I have the foolowing :

.....
BREAK ON field1 SKIP 1
COMPUTE SUM LABEL '' OF field_qty ON field1
.....
SELECT field1, ....., field_qty FROM ....

The result of my SQL is :

field1  .....  field_qty
------        ---------
501120             10.0
                   10.0
                   20.0
                   30.0
******        ---------
                   70.0

501121             15.1
                   10.5
                   10.0
******        ---------
                   35.6

Is it possible to remove ****** and ------- lines from my report? I have not been find a solution yet.

Many thanks in advance for your reply.

SQL> @33

    DEPTNO      EMPNO        SAL
---------- ---------- ----------
        10       7782       2450
        10       7839       5000
        10       7934       1300
                      ----------
                            8750
        20       7369        800
        20       7876       1100
        20       7902       3000
        20       7788       3000
        20       7566       2975
                      ----------
                           10875
        30       7499       1600
        30       7698       2850
        30       7654       1250
        30       7900        950
        30       7844       1500
        30       7521       1250
                      ----------
                            9400

14 rows selected.

SQL> get 33
  1  column dummy noprint
  2  break on dummy
  3  compute sum label 'sum' of sal on dummy
  4  select deptno dummy,deptno,empno,sal from emp
  5* order by dummy;
SQL>