October 11, 2018, 09:31 AM
klofs [CLOSED] DrillDown Error in Page Designer
Hello,
Currently working on a report with a hyperlink drilldown. the rpeort work perfectly in App Studio but when I try to test the report in my content folder in a Page Designer I get the Error "Item does not exist" with the app path that worked in App Studio (IBFS:/WFC/supplychain_reports|podetaildrdwnsup.fex). Not sure If the path needs to be different in the page designer or what?
DrillDown Code in App Studio
INCLUDE = endeflt,
$
TYPE=REPORT,
GRAPHCOLOR='GREEN',
$
TYPE=DATA,
COLUMN=N1,
FOCEXEC=supplychain_reports/podetaildrdwnsup.fex( \
BUYER=&BUYER.QUOTEDSTRING \
PO_STATUS=&PO_STATUS.QUOTEDSTRING \
PO_SHIPMENT_STATUS=&PO_SHIPMENT_STATUS.QUOTEDSTRING \
SUPPLIER_TYPE=&SUPPLIER_TYPE.QUOTEDSTRING \
FROM_DATE=&FROM_DATE.QUOTEDSTRING \
TO_DATE=&TO_DATE.QUOTEDSTRING \
FROM_QUERY='Y' \
TYPE_OF_DATE=&TYPE_OF_DATE.QUOTEDSTRING \
SUPPLIER_NAME=N1 \
),
TARGET='_blank',
$
TYPE=TITLE,
COLUMN=N1,
FOCEXEC=supplychain_reports/podetaildrdwnsup.fex( \
BUYER=&BUYER.QUOTEDSTRING \
PO_STATUS=&PO_STATUS.QUOTEDSTRING \
PO_SHIPMENT_STATUS=&PO_SHIPMENT_STATUS.QUOTEDSTRING \
SUPPLIER_TYPE=&SUPPLIER_TYPE.QUOTEDSTRING \
FROM_DATE=&FROM_DATE.QUOTEDSTRING \
TO_DATE=&TO_DATE.QUOTEDSTRING \
FROM_QUERY='Y' \
TYPE_OF_DATE=&TYPE_OF_DATE.QUOTEDSTRING \
SUPPLIER_NAME=N1 \
),
TARGET='_blank',
$
TYPE=TABHEADING,
SIZE=10,
STYLE=ITALIC,
$
TYPE=REPORT,
OBJECT=MENU,
COLOR='WHITE',
HOVER-COLOR=RGB(66 70 73),
BACKCOLOR=RGB(102 102 102),
HOVER-BACKCOLOR=RGB(218 225 232),
BORDER-COLOR='WHITE',
$
TYPE=REPORT,
OBJECT=STATUS-AREA,
COLOR='WHITE',
BACKCOLOR=RGB(102 102 102),
$
TYPE=REPORT,
OBJECT=CURRENT-ROW,
HOVER-BACKCOLOR=RGB(218 225 232),
BACKCOLOR=RGB(200 200 200),
$
TYPE=REPORT,
OBJECT=CALC-AREA,
COLOR='WHITE',
BACKCOLOR=RGB(102 102 102),
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=2.430556,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=0.763889,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=0.513889,
$
TYPE=REPORT,
COLUMN=N4,
SQUEEZE=0.555556,
$
ENDSTYLE
END
This message has been edited. Last edited by: FP Mod Chuck , October 16, 2018 11:45 AM October 11, 2018, 09:59 AM
Fernando Try changing
FOCEXEC=supplychain_reports/podetaildrdwnsup.fex(
to
FOCEXEC=IBFS:/WFC/supplychain_reports/podetaildrdwnsup.fex(
Fernando
October 11, 2018, 11:08 AM
FP Mod Chuck Klofs
I think Fernando is on the right track but if the fex is in an application folder on the reporting server try this.
IBFS:/EDA/EDASERVE/supplychain_reports/podetaildrdwnsup.fex
If it is in the content area the one slight correction to Fernando's post
IBFS:/WFC/Repository/supplychain_reports/podetaildrdwnsup.fex