Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Comma in subfoot values
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Comma in subfoot values
 Login/Join
 
Member
posted
Hi,

TABLE FILE CAR
PRINT
CAR
SALES/D20C
RPM/D20C
BHP/D20C
BY COUNTRY
ON TABLE SET BYDISPLAY ON
ON COUNTRY SUBTOTAL AS 'Total'
ON COUNTRY SUBFOOT
"Total <+0> <ST.SALES<ST.RPM<ST.BHP"
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBFOOT,COLSPAN=6,HEADALIGN=BODY,JUSTIFY=RIGHT,BACKCOLOR=CYAN,$
TYPE=SUBFOOT,LINE=1,ITEM=1,COLSPAN=1,$
TYPE=SUBFOOT,LINE=1,ITEM=2,COLSPAN=1,$
TYPE=SUBFOOT,LINE=1,ITEM=3,COLSPAN=1,$
TYPE=SUBFOOT,LINE=1,ITEM=4,COLSPAN=1,$
TYPE=SUBFOOT,LINE=1,ITEM=5,COLSPAN=1,$
END

In the above code ,i am displaying the subtotal of a BY field on its SUBFOOT using the ST command. But when i do this i donot get the values comma separated. When i try the same with ON BY-FIELD SUBTOTAL i get the comma separated values.

Is there any method to display the values with commas in the SUBFOOT?

Thankyou,
Ajai.

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


WebFOCUS 7.1.4,Linux,
HTML,PDF,Excel,CSV
 
Posts: 25 | Location: Chennai | Registered: August 27, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
The format changing you are doing is on the fly. When you are doing ST. in Subfoot is going back to the orginal format. Put your format changes in a define and it will work.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
<JG>
posted
Format reassignment does nothing for subtotals.

Use COMPUTE to change the format and then use the computed field in the subfoot.

COMPUTE SALESX/D20C=SALES;
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
That works too.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Both suggestions works fine. Thankyou Praire and JG.

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


WebFOCUS 7.1.4,Linux,
HTML,PDF,Excel,CSV
 
Posts: 25 | Location: Chennai | Registered: August 27, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Comma in subfoot values

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.