Hi to all. My problem: I wish to hide sort field value in SUBTOTAL OR RECOMPUTE command. Any ideas to do that ? (If I use NOPRINT or FOLD-LINE on sort field WF puts the subtotal values of numeric field on 2 lines. If I use IN +n option with BACKCOLOR the output isn't presentable) Thank in advance PaoloThis message has been edited. Last edited by: Kerry,
June 12, 2009, 11:28 AM
GamP
Something like this perhaps:
DEFINE FILE CAR
SPACE/A1 WITH COUNTRY = ' ';
END
TABLE FILE CAR
PRINT CAR MODEL SEATS
BY COUNTRY
BY SPACE NOPRINT AS ''
ON SPACE SUBTOTAL AS 'Total'
END
Hope this helps ...
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
June 12, 2009, 12:48 PM
Darin Lee
Or use SUBFOOT with prefix operators on the columns to get appropriate totals but no label for the sort value. You'll just have to align your subtotal with the appropriate column
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
June 15, 2009, 12:18 PM
Busca
Great GamP, It works fine !!!! Paolo ______________________________________ - Using 715 on AIX 5.3 IE6 IE7 Firefox 3.0 Production - 768 on AIX 5.3 in test