Hi All,

I am calculating the total of one column like below.

TABLE FILE SQLOUT
PRINT
PROCESSDATE AS 'Process Date,'
DESCRIPTION AS 'Description,'
AMOUNT/D30.3 AS 'Outstanding, Shares'
COMMENTS AS 'Comment'
COMMENTDATE AS ''
ON TABLE COLUMN-TOTAL AS 'TOTAL'

but while printing on the report, TOTAL label and AMOUNT column total are coming in different rows. When i try like below then TOTAL label and TOTAL Amount are coming in one row.But i dont want to use the BY in code because no column having unique values.

TABLE FILE SQLOUT
PRINT
PROCESSDATE AS 'Process Date,'
DESCRIPTION AS 'Description,'
AMOUNT/D30.3 AS 'Outstanding, Shares'
COMMENTS AS 'Comment'
COMMENTDATE AS ''
BY PROCESSDATE AS 'Process Date,'
ON TABLE COLUMN-TOTAL AS 'TOTAL'

How to make the TOTAL label and TOTAL AMOUNT values in one row???
Thanks in advance

This message has been edited. Last edited by: santu,

Create a dummy field

Define file xxxx
Dummy/a2='';
End

Table file....
Print
By dummy noprint
On dummy subtotal ...

(All capitals...)

Thanq Frank Dutch
Its solved