As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
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
[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
Posts: 53 | Location: Montreal,Quebec,Canada | Registered: February 13, 2006
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
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006