[CLOSED] Creating PDF output to an unknown drill-down level

I am creating a graph which has a few drilldown levels. On its launch page, I would like to have a link to a pdf document (probably a compound pdf document) which will contain the selection details, as well as the graph.

The problem is that the graph has drill-downs. How can I keep track of what drilldown level I'm at, as well as the drilldown criteria, so the pdf output is generated with the right version of the graph?

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

WebFOCUS & DataMigrator 7.7.03M
Windows 2003, Windows 2008 x64

Posts: 35 | Registered: May 11, 2011

Francis Mariani

Expert

posted

Hide Post

Could you craft the beginnings of a sample program that we can build on?

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Keith MacDonald

Silver Member

posted

Hide Post

Hi Francis,

here's some code that kind of illustrates the problem...

focalpoint.fex

TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST
BY  LOWEST CAR.ORIGIN.COUNTRY
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=DATA,
     COLUMN=N1,
     TARGET='_blank',
     FOCEXEC=focalpoint2( \
     COUNTRYFILTER=N1 \
     ),
$
TYPE=TITLE,
     COLUMN=N1,
     TARGET='_blank',
     FOCEXEC=focalpoint2( \
     COUNTRYFILTER=N1 \
     ),
$
ENDSTYLE
END

focalpoint2.fex

-* File focalpoint2.fex
TABLE FILE CAR
PRINT 
     CAR.ORIGIN.COUNTRY
     CAR.COMP.CAR
     CAR.CARREC.MODEL
     CAR.BODY.DEALER_COST
WHERE CAR.ORIGIN.COUNTRY EQ '&COUNTRYFILTER';
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END

Now suppose you had an html page with this report in a frame, and a link saying "print pdf" or something like that. How would one know which fex you're in (for me, it's the same fex, but parameters controlling BYs and some other things), and what the drill parameters were, so that when you run the pdf you get exactly what's shown in the frame?

Keith

WebFOCUS & DataMigrator 7.7.03M
Windows 2003, Windows 2008 x64

Posts: 35 | Registered: May 11, 2011

Ignored post by Keith MacDonald posted

Show Post

RSquared

Guru

posted

Hide Post

Keith,

You can create a variable, &wherefrom, that you populate in your drill down that tells the called program where you ame from.

WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit

Posts: 398 | Registered: February 04, 2008

Ignored post by RSquared posted