remove zero value in graph

SET LOOKGRAPH=VBAR
SET GRAPHEDIT=SERVER
SET GRID=OFF

DEFINE FILE CAR
SALES/D12 MISSING ON=IF SALES NE 0 THEN SALES ELSE MISSING;
END

SET GRAPHEDIT=ON
SET GRMERGE=ON
GRAPH FILE CAR
SUM SALES
BY CAR
ACROSS COUNTRY
ON GRAPH SET VZERO OFF
ON GRAPH SET GRAPHSTYLE *
setDisplay (getDataText(), true);
setFillMissingData(0);
ENDSTYLE
END
-EXIT

when you run this report, you will see 0 values. I dont want those 0's display in report.

WFConsultant

WF 8105M on Win7/Tomcat

Posts: 780 | Location: Florida | Registered: January 09, 2005

Tony A

Expert

posted

Hide Post

Kamesh,

Raise a case with IB. This problem seems to intermittently raise it's head. I reported in 5.2.3 and also 5.3.2 (case 11992004). However it is fixed in 7.1 (allegedly) so all should be fine. Still, it doesn't help you with 5.3.3!!

For info, this is the example code I sent to IB for the case. It shows both a graph and a table depicting where the null data exists -

-* File graphtst.fex
DEFINE FILE GGSALES
  TYEAR/A4  = EDIT(DATE,'9999$');
  TMONTH/A2 = EDIT(DATE,'$$$$99$');
  TYRMNTH/A6 = EDIT(DATE,'999999$');
END
TABLE FILE GGSALES
SUM   DOLLARS AS GROSS_VALUE
      BUDDOLLARS AS NETT_VALUE
BY    TYEAR
BY    TMONTH
WHERE TYRMNTH LE '199708'
ON TABLE HOLD AS MYDATA
ON TABLE SET ASNAMES ON
ON TABLE SET HOLDLIST PRINTONLY
END
GRAPH FILE MYDATA
SUM   GROSS_VALUE
      NETT_VALUE
ACROSS TMONTH
BY TYEAR
ON GRAPH SET GRAPHEDIT OFF
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ON
ON GRAPH SET GRAPHSTYLE *
setGraphType(41);
ENDSTYLE
END
TABLE FILE MYDATA
SUM   GROSS_VALUE
      NETT_VALUE
BY TMONTH
ACROSS TYEAR
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
ENDSTYLE
END

Regards

T