Hi,
I need little help to resolve this issue.I am working on a SQL*PLUS report. Let's consider the table

TABLE VALUES
VENDOR INVOICE PAYMENT
------ ------- -------
101 001 3,400.00
101 002 1,205.90
101 003 5000.00
789 005 1000.00
789 006 2300.00
415 007 59.09
415 008 700.00
415 009 845.00

in SQL*Plus I am using
BREAK ON vendor SKIP 1
COMPUTE SUM OF payment ON vendor
so what happining, it printing the report result as below format, which is correct.
VENDOR INVOICE PAYMENT
------ ------- -------
101 001 3,400.00
002 1,205.90
003 5,000.00
*** --------
9,605.90

789 005 1,000.00
006 2,300.00
*** --------
3,300.00

415 007 59.09
008 700.00
009 845.00
*** --------
1,604.09

But I need the output in the below layout, how I can manage it?
VENDOR INVOICE PAYMENT
------ ------- -------
101 001 3,400.00
101 002 1,205.90
101 003 5,000.00
--------
9,605.90

789 005 1,000.00
789 006 2,300.00
--------
3,300.00

415 007 59.09
415 008 700.00
415 009 845.00
--------
1,604.09


Thanks in advance.