Focal Point
[SOLVED] SUBTOTAL & sortfield value

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

June 12, 2009, 10:43 AM
Busca
[SOLVED] SUBTOTAL & sortfield value
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
Paolo

This 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