BY EXPLVL ROWS 'SENR' OVER 'MNGR' OVER 'EXTV' OVER '???'should do it for you
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
quote:How do I make the report display for Zero records with the other defined values?
-* this is to create an example of your file TABLE FILE CAR LIST SALES ON TABLE HOLD END DEFINE FILE HOLD PAYLVL/A20 = IF SALES LT 10000 THEN 'AVERAGE' ELSE IF SALES FROM 10001 TO 20000 THEN 'ABOVE AVERAGE' ELSE IF SALES FROM 20001 TO 50000 THEN 'HIGH1' ELSE IF SALES GT 50000 THEN 'HIGH2' ELSE '???'; END -* this creates the line of missing values TABLE FILE HOLD PRINT LIST SALES BY PAYLVL ROWS 'AVERAGE' OVER 'ABOVE AVERAGE' OVER 'HIGH1' OVER 'HIGH2' ON TABLE HOLD AS HOLD1 ON TABLE SET HOLDMISS ON END DEFINE FILE HOLD1 EXPLVL/A20 = DECODE E01('AVERAGE' 'SENR' 'ABOVE AVERAGE' 'MNGR' 'HIGH1' 'EXTV' 'HIGH2' 'EXTV' ELSE '???'); END -* this displays TABLE FILE HOLD1 SUM CNT.LIST SALES BY EXPLVL BY E01 AS PAYLVL END
SET ASNAMES=ON TABLE FILE CAR LIST SALES ON TABLE HOLD END DEFINE FILE HOLD PAYLVL/A20 = IF SALES LT 10000 THEN 'AVERAGE' ELSE IF SALES FROM 10001 TO 20000 THEN 'ABOVE AVERAGE' ELSE IF SALES FROM 20001 TO 50000 THEN 'HIGH1' ELSE IF SALES GT 50000 THEN 'HIGH2' ELSE '???'; END TABLE FILE HOLD PRINT LIST AS NUM SALES BY PAYLVL ROWS 'AVERAGE' OVER 'ABOVE AVERAGE' OVER 'HIGH1' OVER 'HIGH2' ON TABLE HOLD AS HOLD1 ON TABLE SET HOLDMISS ON END DEFINE FILE HOLD1 EXPLVL/A20 = DECODE E01('AVERAGE' 'SENR' 'ABOVE AVERAGE' 'MNGR' 'HIGH1' 'EXTV' 'HIGH2' 'EXTV' ELSE '???'); LEVELS/A40 = EXPLVL | E01; END TABLE FILE HOLD1 SUM CNT.NUM SUM.SALES ON TABLE SAVE END -RUN -READ SAVE &MNUM.A5. &MSALES.A6. -SET &R=INT((&MSALES / &MNUM) / 10000) * 10000; -TYPE &MNUM &MSALES &R -GOTO A TABLE FILE HOLD1 SUM CNT.NUM COMPUTE SAL&R/D6c= SALES / &R; AS 'SALES,&R.s' BY EXPLVL BY E01 AS 'PAYLVL' ON TABLE NOTOTAL ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ GRAPHTYPE=DATA, COLUMN=N3, GRAPHLOOK=BAR, GRAPHCOLOR=RED, $ GRAPHTYPE=DATA, COLUMN=N4, GRAPHLOOK=BAR, GRAPHCOLOR=BLUE, $ TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, COLOR='BLACK', BACKCOLOR='NONE', STYLE=NORMAL, $ TYPE=DATA, COLUMN=N3, COLOR='RED', $ TYPE=DATA, COLUMN=N4, COLOR='BLUE', $ ENDSTYLE END -EXIT -A GRAPH FILE HOLD1 SUM CNT.NUM COMPUTE SAL&R/D6c= SALES / &R; AS 'SALES,&R.s' ACROSS LEVELS ON GRAPH SET LOOKGRAPH 3DPYRAMD ON GRAPH SET GRAPHEDIT SERVER ON GRAPH SET BARNUMB OFF ON GRAPH SET 3D OFF ON GRAPH SET VZERO ON ON GRAPH SET GRID OFF ON GRAPH PCHOLD FORMAT PNG ON GRAPH SET GRAPHSTYLE * setMarkerDisplay(true); setConnectLineMarkers(true); setConnectScatterMarkers(true); setO1LabelDisplay(true); setO1AxisSide(0); setO1MajorGridDisplay(false); setO1MinorGridDisplay(false); setAxisAssignment(0,0); setSeriesType(0,2); setAxisAssignment(1,1); setSeriesType(1,2); setY1LabelDisplay(true); setY1AxisSide(0); setY1MajorGridDisplay(false); setY1MinorGridDisplay(false); setTextFormatPreset(getY1Label(),-1); setTextFormatPattern(getY1Label(),"#.##"); setY2LabelDisplay(true); setY2AxisSide(1); setY2MajorGridDisplay(false); setY2MinorGridDisplay(false); setTextFormatPreset(getY2Label(),-1); setTextFormatPattern(getY2Label(),"#.##"); setPieFeelerTextDisplay(1); setPieLabelDisplay(0); setTextFormatPreset(getPieSliceLabel(),1); setRiserBorderMode(1); setSeriesDefaultTransparentBorderColor(true); setUseSeriesBorderDefaults(true); setLegendDisplay(true); setFontSizeAbsolute(getY1Title(),true); setFontSizeAbsolute(getY1Label(),true); setFontSizeAbsolute(getY2Title(),true); setFontSizeAbsolute(getY2Label(),true); setFontSizeAbsolute(getO1Title(),true); setPlace(true); ENDSTYLE ON GRAPH SET STYLE * PAGESIZE='Letter', LEFTMARGIN=0.250000, RIGHTMARGIN=0.250000, TOPMARGIN=0.250000, BOTTOMMARGIN=0.250000, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, BACKCOLOR='NONE', STYLE=NORMAL, $ TYPE=DATA, ACROSSCOLUMN=N1, COLOR='RED', $ TYPE=DATA, ACROSSCOLUMN=N2, COLOR='BLUE', $ ENDSTYLE END
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |