Focal Point
[SOLVED[ Hyperlink JSCHART

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

August 17, 2018, 01:26 PM
evan.brown
[SOLVED[ Hyperlink JSCHART
When I run the following, I only get the hyperlink for the first instance. Any idea why? When I do it without declaring the COLUMN, it seems to work fine. Thanks
  
GRAPH FILE CAR
SUM
WEIGHT
DEALER_COST	
RETAIL_COST
ACROSS COUNTRY
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET LOOKGRAPH HBAR
ON GRAPH SET STYLE *
TYPE=DATA, TARGET='_blank', COLUMN=WEIGHT, FOCEXEC=test_hyperlink_rpt(COUNTRY=COUNTRY), $
TYPE=DATA, TARGET='_blank', COLUMN=DEALER_COST, FOCEXEC=test_hyperlink_rpt(COUNTRY=COUNTRY), $
TYPE=DATA, TARGET='_blank', COLUMN=RETAIL_COST, FOCEXEC=test_hyperlink_rpt(COUNTRY=COUNTRY), $
ENDSTYLE
END

This message has been edited. Last edited by: FP Mod Chuck,


WF 8.0.08 (Prod); WF 8.2.06 (Dev)
August 17, 2018, 01:57 PM
MartinY
In your case it seems that you drill the same way no matter the clicked measure, use as below
GRAPH FILE CAR
SUM
WEIGHT
DEALER_COST	
RETAIL_COST
ACROSS COUNTRY
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET LOOKGRAPH HBAR
ON GRAPH SET STYLE *
-*TYPE=DATA, TARGET='_blank', COLUMN=WEIGHT, FOCEXEC=test_hyperlink_rpt(COUNTRY=COUNTRY), $
-*TYPE=DATA, TARGET='_blank', COLUMN=DEALER_COST, FOCEXEC=test_hyperlink_rpt(COUNTRY=COUNTRY), $
-*TYPE=DATA, TARGET='_blank', COLUMN=RETAIL_COST, FOCEXEC=test_hyperlink_rpt(COUNTRY=COUNTRY), $

TYPE=DATA, TARGET='_blank', FOCEXEC=test_hyperlink_rpt(COUNTRY=COUNTRY), $
ENDSTYLE
END

To have specific styling per across column, use the below
GRAPH FILE CAR
SUM
WEIGHT
DEALER_COST	
RETAIL_COST
ACROSS COUNTRY
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET LOOKGRAPH HBAR
ON GRAPH SET STYLE *
TYPE=DATA, TARGET='_blank', ACROSSCOLUMN=WEIGHT, FOCEXEC=111_hyperlink_rpt(COUNTRY=COUNTRY), $
TYPE=DATA, TARGET='_blank', ACROSSCOLUMN=DEALER_COST, FOCEXEC=222_hyperlink_rpt(COUNTRY=COUNTRY), $
TYPE=DATA, TARGET='_blank', ACROSSCOLUMN=RETAIL_COST, FOCEXEC=333_hyperlink_rpt(COUNTRY=COUNTRY), $

-*TYPE=DATA, TARGET='_blank', FOCEXEC=test_hyperlink_rpt(COUNTRY=COUNTRY), $
ENDSTYLE
END

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


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
August 17, 2018, 02:55 PM
evan.brown
ACROSSCOLUMN! Thank You!


WF 8.0.08 (Prod); WF 8.2.06 (Dev)