[SOLVED] Total label and total amount coming in different lines
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 advanceThis message has been edited. Last edited by: santu,
Web FOCUS 7.7.03 PDF
June 01, 2013, 08:09 AM
Create a dummy field
Define file xxxx Dummy/a2=''; End
Table file.... Print By dummy noprint On dummy subtotal ...
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