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,

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

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

Keith,

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