Focal Point
[CLOSED] ACROSS column not working in Graphs for FORMAT FLEX

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1727082816

March 26, 2012, 09:26 AM
Suji
[CLOSED] ACROSS column not working in Graphs for FORMAT FLEX
Hello,
ACROSS Column which works in GRAPHs normally does not work for FORMAT FLEX in Graphs. Can someone suggest a solution for this WebFOCUS issue?

Thanks,
Suji.

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


WebFOCUS 7.7.02(Production)
WebFOCUS 7.7.02(Test region)
Oracle backend (10g)and Windows Frontend.
HTML,PDF,EXL2K,FLEX,AHTML
March 26, 2012, 10:14 AM
TexasStingray
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

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.


WebFOCUS 7.7.02(Production)
WebFOCUS 7.7.02(Test region)
Oracle backend (10g)and Windows Frontend.
HTML,PDF,EXL2K,FLEX,AHTML
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

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

Thanks,
Suji


WebFOCUS 7.7.02(Production)
WebFOCUS 7.7.02(Test region)
Oracle backend (10g)and Windows Frontend.
HTML,PDF,EXL2K,FLEX,AHTML
Hi Suji,

That is correct. I also experienced it.

I suggest you open a case with IBI.


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

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
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

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
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


WebFOCUS 8
Windows 7, All Outputs