Suppress/Override sql+ compute functions message

Hi Netters,

I have an SQL*Plus script with

    "COMPUTE SUM OF INV_AMOUNT ON SOURC REPORT" The above statement is to have a subtotal break on source (field) and grand total at the end of the report. In the output, it shows "sum" label in both the places. It is not meaning in the user side. Ofcourse programmers can understand it. Instead I want to print my own label "Subtotal" and "Grand total" in the above said places. By this time, some one of you would have faced the same problem. So, How will you suppress/override the computational functions label in SQL*PLUS.

E.g

SOURC COMP.INV INV Date INV AMOUNT

-----  --------  ---------  --------------------
CMS    0740352A  13-JAN-94             $2,838.38
CMS    0740501A  17-JAN-94             $1,533.48
CMS    0740711A  20-JAN-94            $54,386.57
CMS    0740725A  20-JAN-94             $5,278.84
*****                       --------------------
sum                                   $64,037.27    (suppose to be subtotal)

DBS    01915213  28-JAN-94               $232.00
DBS    01915217  28-JAN-94               $243.60
DBS    05819803  13-JAN-94               $426.40


                            --------------------

sum                                      $901.00    (suppose to be subtotal)



                            --------------------

sum                                   $64,938.27    (suppose to be Grandtotal)

Any help is appreciated.

Cheers,
palani_at_wslvax1.wipsys.soft.net Received on Sun Mar 19 1995 - 18:07:06 CST