Are you wanting to create a chart for each across item? can you give some details on want you are trying to accomplish. FLEX works a little different as it is an Active Report.
Scott
March 26, 2012, 10:43 AM
Suji
This is a sample code GRAPH FILE SQLOUT SUM DEALER_COST ACROSS COUNTRY ON GRAPH PCHOLD FORMAT FLEX END
This does not work for FLEX. But it will work for other formats. I am trying to segregate the data using Country field.
I think that for FLEX, you should not use ACROSS but BY:
-* File graph01.fex
GRAPH FILE CAR
SUM DEALER_COST
BY COUNTRY
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT FLEX
END
See what happens when you use both BY and ACROSS
GRAPH FILE CAR
SUM DEALER_COST
BY COUNTRY
ACROSS SEATS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRID OFF
ON GRAPH PCHOLD FORMAT FLEX
END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
March 30, 2012, 01:54 AM
Suji
Hi Danny, I tried your code .This is the sample code I tried. Legend names are displaying as SUM.COST, SUM.COST [1], SUM.COST [2], SUM.COST [3] and SUM.COST [4] instead of displaying the ACROSS column values for Country (ENGLAND, FRANCE ..etc as Legend names). GRAPH FILE CAR SUM DEALER_COST AS 'COST' ACROSS COUNTRY AS 'COUNTRY' BY SEATS AS 'SEATS' ON GRAPH SET LOOKGRAPH VBAR ON GRAPH SET GRAPHEDIT SERVER ON GRAPH SET BARNUMB ON ON GRAPH SET 3D ON ON GRAPH SET VZERO ON ON GRAPH SET GRID OFF ON GRAPH PCHOLD FORMAT FLEX END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
June 26, 2012, 09:25 AM
Jamila
I am also having similar issue and have opened a case with IBI without any good luck..PLease post the solution if you come across one. My code is as follows: TABLE FILE A_ELIG_GRAPH_TESTDATA PRINT A_ELIG_GRAPH_TESTDATA.A_ELIG_GRAPH_TESTDATA.TOT_CNT BY A_ELIG_GRAPH_TESTDATA.A_ELIG_GRAPH_TESTDATA.REPORT_TYPE ACROSS A_ELIG_GRAPH_TESTDATA.A_ELIG_GRAPH_TESTDATA.YEAR_NAME WHERE A_ELIG_GRAPH_TESTDATA.A_ELIG_GRAPH_TESTDATA.GROUP_TYPE EQ 'Gender'; ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT AHTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * $ TYPE=REPORT, GRAPHCOLOR='GREEN', GRAPHCOLORNEG='RED', $ TYPE=REPORT, LINES-PER-PAGE=20, ARGRAPHENGINE=FUSION, REPORT-VIEW=FUSIONCHART, CHART-TYPE=MSColumn3D, $
7.7.03, Windows
June 06, 2013, 11:05 AM
zshanks
Has anyone solved this issue? I'm currently having the same problem with my legend displaying as SUM.COLUMN[1], SUM.COLUMN[2], and SUM.COLUMN[3] instead of their respective ACROSS values (CAR, PLANE, TRAIN... etc. as Legend names).
WebFOCUS 7.7.03 Dev Studio 7.7.03 Windows 7 ALL Outputs
July 11, 2013, 03:38 PM
BI_Developer
Hello
Any fix to this?
Trying to get simple FLEX or AHTML chart for this code
GRAPH FILE CAR
SUM DEALER_COST AS 'COST'
ACROSS COUNTRY AS 'COUNTRY'
BY SEATS AS 'SEATS'
END
Thank you..!
WF 8.2.01 APP STUDIO PDF,HTML,EXL2K,Active
September 10, 2014, 10:59 AM
snk5098
Has anyone found a solution to this issue? Can't seem to get active reports to work properly while using an ACROSS. Legend displays SUM.COLUMN[1], SUM.COLUMN[2], SUM.COLUMN[3]....as well