Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Formatting SUBTOTAL on Excel with COMPOUND=BYTOC

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Formatting SUBTOTAL on Excel with COMPOUND=BYTOC
 Login/Join
 
Gold member
posted
Hi,

SET LINES = 99999
SET BYDISPLAY = ON
SET COMPOUND = BYTOC

TABLE FILE CAR
PRINT 
COUNTRY
CAR
MODEL
SALES
BY COUNTRY NOPRINT
ON COUNTRY SUBTOTAL SALES AS ''
ON TABLE PCHOLD FORMAT EXL2K
END


To sum up my problem, with this code I get this:

ENGLAND JAGUAR V12XKEAUTO 0
ENGLAND JAGUAR XJ12LAUTO 12000
ENGLAND JENSEN INTERCEPTORIII 0
ENGLAND TRIUMPH TR7 0
ENGLAND
BLANK BLANK BLANK 12000

But I would like to obtain this:

ENGLAND JAGUAR V12XKEAUTO 0
ENGLAND JAGUAR XJ12LAUTO 12000
ENGLAND JENSEN INTERCEPTORIII 0
ENGLAND TRIUMPH TR7 0
BLANK BLANK BLANK 12000

Any idea? I looked for a solution on the Webfocus Help and on this forum but I didn't find the solution.

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


WebFOCUS 7.6.4 running on Windows
Output formats : PDF, Excel and HTML
My blog
 
Posts: 61 | Location: Luxembourg | Registered: October 31, 2007Report This Post
Virtuoso
posted Hide Post
To get the output the way you want, I think you will need to use SUBFOOT instead of SUBTOTAL. Try this:

SET LINES = 99999
SET BYDISPLAY = ON
SET COMPOUND = BYTOC

TABLE FILE CAR
 PRINT 
  COUNTRY
  CAR
  MODEL
  SALES
 BY COUNTRY NOPRINT
 ON COUNTRY SUBFOOT
  "<+0> <+0> <+0> <ST.SALES "
 ON TABLE PCHOLD FORMAT EXL2K
 ON TABLE SET STYLE *
  TYPE=SUBFOOT, HEADALIGN=BODY, $
 ENDSTYLE
END


Edit: Need to use ST.SALES instead of TOT.SALES in the SUBFOOT.

This message has been edited. Last edited by: Dan Satchell,


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Gold member
posted Hide Post
i posted this just after Dan, his method would be better, im using the dirty 'white text' method to do some painting over.

===================================


This should do it


SET LINES = 99999
SET BYDISPLAY = ON
SET COMPOUND = BYTOC
DEFINE FILE CAR
BLANK/A1 WITH COUNTRY='';
END


TABLE FILE CAR
PRINT
CAR
MODEL
SALES
BY COUNTRY
BY BLANK NOPRINT

ON COUNTRY SUBTOTAL AS ''

ON BLANK SUBTOTAL AS ' '
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=10,
$
TYPE=SUBTOTAL,
BY=1,
COLOR='WHITE',
$
ENDSTYLE
END


81.05 All formats
 
Posts: 56 | Location: Manchester | Registered: November 21, 2006Report This Post
Expert
posted Hide Post
I think that only the BLANK option is needed.

SET LINES = 99999
SET BYDISPLAY = ON
SET COMPOUND = BYTOC

DEFINE FILE CAR
 BLANK/A1 = ' ' ;
END

TABLE FILE CAR
PRINT 
COUNTRY
CAR
MODEL
SALES
BY COUNTRY NOPRINT
BY BLANK NOPRINT
ON BLANK SUBTOTAL SALES AS ''
ON TABLE PCHOLD FORMAT EXL2K
END


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
Thanks guys, I will try these solutions and give you my feedback.


WebFOCUS 7.6.4 running on Windows
Output formats : PDF, Excel and HTML
My blog
 
Posts: 61 | Location: Luxembourg | Registered: October 31, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Formatting SUBTOTAL on Excel with COMPOUND=BYTOC

Copyright © 1996-2020 Information Builders