I have a compound pdf report in release 7.6.11. I have a drill through that is working, the report drill throughs to a value in the second report. I am trying to add a drilldown as well to the first report. When I do this, neither the drill through or the drilldown work. Are the drill through and drilldown mutually exclusive?

Hi Chuckie,

Per our technicals: You can mix conventional Drill Down hyperlinks freely in the same report with Drill Through hyperlinks. Are you getting an error? Can you post some code of the problem?

Cheers,

Kerry

Tis is the code I am using.

COMPOUND LAYOUT PCHOLD FORMAT PDF
-*
-**
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5',
MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE='Legal', $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1',
TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5,
METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,ORIENTATION=LANDSCAPE,', $
COMPONENT='REPORT1', TEXT='REPORT1', TOC-LEVEL=1,
DRILLMAP=((L1 REPORT2)), POSITION=(0.750 1.083), DIMENSION=(* *),
METADATA='Z-INDEX: 100; LEFT: 0.75in; OVERFLOW: auto; WIDTH: 13in; POSITION: absolute; TOP: 1.0in; HEIGHT: 1.167in', $
PAGELAYOUT=2, NAME='Page layout 2', text='Page layout 2',
TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5,
METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,ORIENTATION=LANDSCAPE,', $
COMPONENT='REPORT2', TEXT='REPORT2', TOC-LEVEL=1,
DRILLMAP=((L1 REPORT1)), POSITION=(0.500 0.667), DIMENSION=(* *),
METADATA='Z-INDEX: 100; LEFT: 0.75in; OVERFLOW: auto; WIDTH: 13in; POSITION: absolute; TOP: 1.0in; HEIGHT: 1.167in', $
END
-* Add Report1 code and SET COMPONENT command
SET COMPONENT='REPORT1'

DEFINE FILE AUDITFIL
DISPLAY_TIME/HYYMDS = IF FOLDER_TYPE EQ 'RID' THEN WORKITEM_CREATION_DATE ELSE BATCH_CREATION_DATE ;
DISPLAY_BATCH/A48 = IF HIERARCHY_FIELD CONTAINS '-' THEN HIERARCHY_FIELD ELSE LAST DISPLAY_BATCH;
END
TABLEF FILE AUDITFIL
PRINT
SORTFIELD NOPRINT
'AUDITFIL.AUDITFIL.HIERARCHY_FIELD' AS 'Hierarchy'
'AUDITFIL.AUDITFIL.DISPLAY_TIME' AS 'Batch Create,Workitem Create'
'AUDITFIL.AUDITFIL.WORKITEM_INJECT_DATE' AS 'Inject Date'
'AUDITFIL.AUDITFIL.PC_TO_INJECTION_CYCLE_TIME' AS 'Cycle Time'
'AUDITFIL.AUDITFIL.XTRAC_INJECT_ID' AS 'XTRAC Item'
'AUDITFIL.AUDITFIL.DISPLAY_BATCH' NOPRINT


HEADING
"Batch and RID Hierarchy Overview Report"
""
"Report Request: &REQUEST"
""
"FOOTING
"Report Prepared: <+0>&DATEtrMDYY <+0> at &TOD <+0> "
"- Fidelity Internal Information -"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Legal',
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='WHITE',
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=1,
COLOR=GREEN,
-* FOCEXEC=app/newformat1(REQUEST=DISPLAY_BATCH ),
$
TYPE=DATA,
COLUMN=N2,
DRILLTHROUGH=DOWN( HIERARCHY_FIELD ),
STYLE=-UNDERLINE,
COLOR=BLUE,
$
TYPE=DATA,
COLUMN=N3,
JUSTIFY=LEFT,

$
TYPE=TITLE,
COLUMN=N3,
JUSTIFY=LEFT,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=2.000000,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=2.000000,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=1.500000,
$
TYPE=REPORT,
COLUMN=N4,
SQUEEZE=1.402778,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=1.502778,
$
TYPE=REPORT,
COLUMN=N6,
SQUEEZE=1.502778,
$
ENDSTYLE
END
-* Add report code and SET COMPONENT command
SET COMPONENT='REPORT2'
SET SQUEEZE=ON
-*
DEFINE FILE COMBINED
PROCESS_END_TIME/HYYMDS = HADD(PROCESS_START_TIME, 'SECOND', TIME_IN_PROCESS, 8, PROCESS_END_TIME);
OP_NAME_ID/A150 = FULL_NAME || ' (' || CORP_ID || ')';
BATCH_INDICATOR/A1 = IF FOLDER_NAME CONTAINS '-' THEN 'Y' ELSE 'N';
WRK_ITM_NME/A1 = EDIT ( XTRAC_INJECT_ID , '9' );
WRK_ITM_NUM/A7 = EDIT ( XTRAC_INJECT_ID , '$$$$$$$$$9999999' );
WRK_ITM_DTE_DAY/A2 = EDIT ( XTRAC_INJECT_ID , '$$$$$$$99' );
WRK_ITM_DTE_MONTH/A2 = EDIT ( XTRAC_INJECT_ID , '$$$$$99' );
WRK_ITM_DTE_YEAR/A4 = EDIT ( XTRAC_INJECT_ID , '$9999' );
WRK_ITM_TOT/A3 = DECODE WRK_ITM_DTE_MONTH (
'01' 'Jan'
'02' 'Feb'
'03' 'Mar'
'04' 'Apr'
'05' 'May'
'06' 'Jun'
'07' 'Jul'
'08' 'Aug'
'09' 'Sep'
'10' 'Oct'
'11' 'Nov'
'12' 'Dec'
ELSE 'ERR');
WRK_ITM_TOTAL/A25 = IF WRK_ITM_TOT EQ 'ERR' THEN 'Not Injected into XTRAC' ELSE
WRK_ITM_NME || WRK_ITM_NUM || '-' || WRK_ITM_DTE_DAY || WRK_ITM_TOT || WRK_ITM_DTE_YEAR;
SUBHEADING1/A150 = IF BATCH_INDICATOR EQ 'Y' THEN 'Scanner:' | BATCH_CREATION_DEVICE_ID
ELSE 'Xtract Workitem #' | WRK_ITM_TOTAL;
SUBHEADING2/A150 = IF BATCH_INDICATOR EQ 'Y' THEN 'Batch Type: ' | BATCH_TYPE
ELSE 'First Scan Ref: ' | WORKITEM_FIRST_IMAGE_SCAN_REF;


END
TABLE FILE COMBINED
PRINT
CLIENT AS 'Client'
WORKTYPE AS 'Work Type'
PROCESS_START_TIME AS 'Application Start'
PROCESS_END_TIME AS 'Application End'
PROCESS_NAME AS 'Application'
PROCESS_STATUS AS 'Status'
PRIORITY AS 'Priority'
OP_NAME_ID AS 'Operator'
CITY AS 'Location'
BY SORTFIELD NOPRINT
BY HIERARCHY_FIELD NOPRINT
ON HIERARCHY_FIELD SUBHEAD
""
"--- Return to Summary Report ---"
"""
""
BY PROCESS_START_TIME NOPRINT
FOOTING
"Report Prepared: <+0>&DATEtrMDYY <+0> at &TOD <+0> "
"- Fidelity Internal Information -"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=.25,
RIGHTMARGIN=.25,
TOPMARGIN=.25,
BOTTOMMARGIN=.25,
RIGHTGAP=.05,
LEFTGAP=.05,
SQUEEZE=ON,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='WHITE',
STYLE=NORMAL,
$
TYPE=SUBHEAD, LINE=3, ITEM=1, DRILLTHROUGH=FIRST(HIERARCHY_FIELD ),
COLOR=RED, $
END
COMPOUND END

When I uncomment the DRILLDOWN, the DRILLDOWN does not work nor does the drill thru work. I do not get an error message. It appears that neither drillthrough and drilldown are no longer hyperlinks.

Web FOCUS 7.6.11
AIX
Output: EXCEL, PDF, HTML,
AHTML