Focal Point
[SOLVED] Drill down not working on Graph in PDF format

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

December 18, 2014, 08:31 AM
koti
[SOLVED] Drill down not working on Graph in PDF format
I have PDF compound report that contains graphs and reports. Drill down is working when i create the graph separately but not when i include in Document composer to build compound report.
Please suggest me is there any way to build this report. Thanks in advance!


 Main report:
------------

SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $

PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='graph1', TEXT='graph1', TOC-LEVEL=2, POSITION=(1.250 0.833), DIMENSION=(4.474 2.921), COMPONENT-TYPE=GRAPH, METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 4.474in; HEIGHT: 2.921in; TOP: 0.833in; LEFT: 1.25in', $
END
SET COMPONENT='graph1'
-*component_type graph
-*focexectool
GRAPH FILE CAR
SUM RETAIL_COST
BY COUNTRY
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET STYLE *
TYPE=DATA, FOCEXEC=app/drilldown2(PARAMETER=COUNTRY), $
ENDSTYLE
END
COMPOUND END


Drilldown report:
------------------

TABLE FILE CAR
PRINT
     RETAIL_COST 
BY COUNTRY
WHERE (COUNTRY EQ '&PARAMETER');
END
 


Koti.
WebFOCUS 7703, Windows 7, Oracle DB.

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8104/7703/769/764, Windows 7, Oracle 11g, DB2, QAD
December 18, 2014, 09:46 AM
<nick z>
Hi Koti,
Drilldown is not supported for graphs in PDF format. The best workaround for this is to create a compound Document with both Report and Graph and set up the drilldown on the Report component.
Thank you.
Nick.
December 18, 2014, 11:54 PM
Ram Prasad E
Drill on graph item supported only in HTML format.


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/