[CLOSED] PDF drillthrough for compound pdf with mutiple hold files

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,

Webfocus 7.1.4
Unix/Windows
Excel,PDF,HTML,Printer Friendly

Posts: 1 | Registered: July 21, 2009