Hi,

I am trying to apply drillthrough option in a compound PDF which is generated using multiple hold files.
The code is as below

SQL SQLORA
select distinct appl_tx from DSUT_DSPL_SUMM;

TABLE FILE SQLOUT
PRINT
*
ON TABLE HOLD AS URDATA
END

SQL SQLORA
select appl_tx,count(distinct CATG_TX) cnt from DSUT_DSPL_SUMM group by appl_tx;

TABLE FILE SQLOUT
PRINT
*
ON TABLE HOLD AS CNTDATA
END

TABLE FILE URDATA
PRINT
APPL_TX
ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET STYLE *
TYPE=DATA, COLOR=RED, DRILLTHROUGH=DOWN(APPL_TX), $
ENDSTYLE
END

TABLE FILE CNTDATA
SUM CNT
BY APPL_TX NOPRINT
WHERE APPL_TX EQ 'Document Processing'
ON APPL_TX PAGE-BREAK
HEADING CENTER
"ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET STYLE *
TYPE=HEADING, COLOR=RED,$
ENDSTYLE
END


TABLE FILE CNTDATA
SUM CNT
BY APPL_TX NOPRINT
WHERE APPL_TX EQ 'Asset Movement Processing System'
ON APPL_TX PAGE-BREAK
HEADING CENTER
"ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET STYLE *
TYPE=HEADING, COLOR=RED,$
ENDSTYLE
END



TABLE FILE CNTDATA
SUM CNT
BY APPL_TX NOPRINT
WHERE APPL_TX EQ 'Entitlement Management'
ON APPL_TX PAGE-BREAK
HEADING CENTER
"ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET STYLE *
TYPE=HEADING, COLOR=RED,$
ENDSTYLE
END



TABLE FILE CNTDATA
SUM CNT
BY APPL_TX NOPRINT
WHERE APPL_TX EQ 'Service Center'
ON APPL_TX PAGE-BREAK
HEADING CENTER
"ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET STYLE *
TYPE=HEADING, COLOR=RED,$
ENDSTYLE
END


The issue is that i am able to drillthrough from the first page(source page) only to the next immediate page and not to the subsequent pages (3rd ,4th.....).

Is there a way to implement the pdf drillthrough to mutiple target files ?

Thanks in advance.

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

quote:

TYPE=DATA, COLOR=RED, DRILLTHROUGH=DOWN(APPL_TX), $

Should you not repeat this statement for all subsequent reports also?