Focal Point
[CASE-OPENED] Hyperlinks in compound PDF report using DRILLTHROUGH and DRILLMAP

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

July 15, 2009, 05:29 PM
CT
[CASE-OPENED] Hyperlinks in compound PDF report using DRILLTHROUGH and DRILLMAP
I have a compound PDF report where the name and number of COMPONENTs vary based on data. I have the similar example using CAR file posted in my previous post, Saving burst value as an amper variable.

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

-*-- LOOP1 - Process each country --------------------------------------------------------
-REPEAT LOOP1 &countryCount TIMES

-SET &LAYOUTNUM = 1;
PAGELAYOUT=&LAYOUTNUM, NAME='Page layout &LAYOUTNUM', text='Page layout &LAYOUTNUM', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=1.0, $

COMPONENT='report&countryCtr', TEXT='report&countryCtr', TOC-LEVEL=2, POSITION=(0.5 1.000), DIMENSION=(* *), $

-*-- LOOP2 - Process each car --------------------------------------------------
-REPEAT LOOP2 &carCount.&countryCtr TIMES

-SET &LAYOUTNUM = &LAYOUTNUM + 1;
-SET &GPHNUM = &carCounter + 1 ;
-SET &RPTNUM = &carCounter + 1;
-SET &REPORTNUM = &carCounter + 1;


PAGELAYOUT=&LAYOUTNUM, NAME='Page layout &LAYOUTNUM', text='Page layout &LAYOUTNUM', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=1.0, $
COMPONENT='graph&GPHNUM', TEXT='graph&GPHNUM', TOC-LEVEL=2, POSITION=(1 0.000), DIMENSION=(* *), $
COMPONENT='rpt&RPTNUM', TEXT='rpt&RPTNUM', TOC-LEVEL=2, POSITION=(+0.0 +3.0), DIMENSION=(* *), RELATIVE-TO='graph&GPHNUM', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, $
COMPONENT='rep&REPORTNUM', TEXT='rep&REPORTNUM', TOC-LEVEL=2, POSITION=(+0.000 +0.0), DIMENSION=(* *), RELATIVE-TO='rpt&RPTNUM', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, $


-SET &carCounter = &carCounter + 1;
-LOOP2

-SET &countryCtr = &countryCtr + 1;

-LOOP1
END

The Country report (report&countryCtr)has hyperlinks for each of the cars which need to link to the corresponding car report (rpt&RPTNUM). I am planning to use DRILLTHROUGH in reports and DRILLMAP in compound PDF code. But DRILLMAP needs the COMPONENT name it's linking to (DRILLMAP=((L1 rep&REPORTNUM))). Since COMPONENT names are dynamic here, I am not sure how to accomplish this.
Without using DRILLMAP, are there any other ways of getting the hyperlinks work.
Thanks.

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


7.6.9, XP