HI, I used the graph output format as 'PDF' in main graph .In that main graph report, Also used the drilldown .I'm getting the PDF Output for main graph report,but i'm not able to use the Drilldown on PDF. Here is example code for MAIN & DRILLDOWN: Main :
GRAPH FILE CAR -* Created by Advanced Graph Assistant SUM CAR.BODY.RETAIL_COST BY CAR.COMP.CAR ON GRAPH HOLD AS CHR1 FORMAT SVG ON GRAPH SET GRAPHDEFAULT OFF ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 0 ON GRAPH SET GRXAXIS 1 ON GRAPH SET HAXIS 8 ON GRAPH SET VAXIS 4 ON GRAPH SET UNITS INCHES ON GRAPH SET LOOKGRAPH VBAR2AX ON GRAPH SET GRAPHSTYLE * setTemplateFile("/images/tdg/template/IBISouthWestern.txt"); setReportParsingErrors(false); setSelectionEnableMove(false); setDepthRadius(5); setPlace(true); ENDSTYLE ON GRAPH SET STYLE * TYPE=DATA, COLUMN=N2, FOCEXEC=forum_drill(CAR=CAR.COMP.CAR), $ ENDSTYLE END TABLE FILE CAR " " BY CAR.COMP.CAR NOPRINT IF RECORDLIMIT EQ 1 ON TABLE SET PAGE-NUM NOLEAD ON TABLE PCHOLD FORMAT PDF ON TABLE SET STYLE * type=HEADING, IMAGE=CHR1.SVG, position=(0 0), $ END
DRILLDOWN: GRAPH FILE CAR -* Created by Advanced Graph Assistant SUM CAR.BODY.DEALER_COST BY CAR.CARREC.MODEL WHERE (CAR.COMP.CAR EQ '&CAR'); ON GRAPH HOLD AS CHR1 FORMAT SVG ON GRAPH SET GRAPHDEFAULT OFF ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 0 ON GRAPH SET GRXAXIS 1 ON GRAPH SET HAXIS 8 ON GRAPH SET VAXIS 4 ON GRAPH SET UNITS INCHES ON GRAPH SET LOOKGRAPH VBAR2AX ON GRAPH SET GRAPHSTYLE * setTemplateFile("/images/tdg/template/IBISouthWestern.txt"); setReportParsingErrors(false); setSelectionEnableMove(false); setDepthRadius(5); setPlace(true); ENDSTYLE END TABLE FILE CAR " " BY CAR.COMP.CAR NOPRINT IF RECORDLIMIT EQ 1 ON TABLE SET PAGE-NUM NOLEAD ON TABLE PCHOLD FORMAT PDF ON TABLE SET STYLE * type=HEADING, IMAGE=CHR1.SVG, position=(0 0), $ END -------- PROD: WEBFOCUS 7.6.4 on WINDOWS XP/ WINDOWS NT TEST: WEBFOCUS 7.6.1 on WINDOWS XP/ WINDOWS NTThis message has been edited. Last edited by: PRAKASH N V,
WF: WebFOCUS 7.6.4/7.6.8/7.6.10/7702/7703 Windows: XP/NT, Output formats: HTML,PDF,EXCEL,ACTIVE HTML
September 24, 2008, 10:59 AM
LEX-IA
As per Kerry
[CODE] – This should be placed in the subject title when the information in the post is not a question but rather is a piece of code that may be helpful to other Focal Point members. This will communicate that there is not a question in the thread that needs to be answered.
Basically you should remove the word CODE from your topic title....
PROD: WebFOCUS 7.1.0 on Linux/Tomcat 5.5.12 (standalone)/Informix on AIX TEST: WebFOCUS 7.1.3 on Linux/Tomcat 5.5.16 (standalone)/Informix on AIX
September 24, 2008, 11:01 AM
GinnyJakes
And you should put your code between the code tags: >.
Also, please update your profile signature with your products, releases, and platforms.
You can't drill down from your PDF graph because your graph is an image not individual components.
Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes
September 26, 2008, 03:47 AM
PRAKASH N V
Is any other posible way to make a drilldown in Graph as PDF Output format ?
-------------- PROD: WEBFOCUS 7.6.4 on WINDOWS XP/ WINDOWS NT TEST: WEBFOCUS 7.6.1 on WINDOWS XP/ WINDOWS NT
WF: WebFOCUS 7.6.4/7.6.8/7.6.10/7702/7703 Windows: XP/NT, Output formats: HTML,PDF,EXCEL,ACTIVE HTML
September 29, 2008, 06:34 AM
FrankDutch
No
As Pat stated, the graph is an image. What I would do (and did) is create a kind of legend and put the desired drill-troughs into that part of coding.
It's however not a very good solution, since you can send an pdf outside the company network and what will happen if the receiver of that reports wants to drill down to the next child report?
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7