Focal Point
[SOLVED] Total label and total amount coming in different lines

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1817002136

June 01, 2013, 05:06 AM
santu
[SOLVED] Total label and total amount coming in different lines
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,


Web FOCUS 7.7.03
PDF
June 01, 2013, 08:09 AM
FrankDutch
Create a dummy field

Define file xxxx
Dummy/a2='';
End

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

(All capitals...)




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

June 04, 2013, 08:06 AM
santu
Thanq Frank Dutch
Its solved


Web FOCUS 7.7.03
PDF