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] change field description when using the ON command
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] change field description when using the ON command
 Login/Join
 
Gold member
posted
I want to do subtotals on department but instead of displaying the dept number
the user would like to see the department description.

ON DEPARTMENT_X SUBTOTAL AS ?????

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


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Dave,

Try this:
  
-* File DaveZ01.fex
DEFINE FILE CAR
SEATER/A6=DECODE SEATS(2 SPORT 4 FAMILY 5 WAGON);
END
TABLE FILE CAR
SUM SALES 
BY SEATS
BY SEATER NOPRINT
BY CAR
ON SEATER SUBTOTAL AS SEATS
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 INCLUDE=ENDEFLT,
$
ENDSTYLE
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1934 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
You are saying I need to code for all 200 + departments


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
The other option is to use SUBFOOT.
ON DEP_CODE SUBFOOT
"<DEP_DESC <ST.Field1 <ST.Field2 <ST.Field3"  


You will need to do styling to position the items in the footing


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6115 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Dave,
quote:
You are saying I need to code for all 200 + departments

I did a DECODE because in the CAR file there is no "description" for SEATS...

You probably have a field for the department name. Use that!


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1934 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks for all the help


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] change field description when using the ON command

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