Focal Point
[CLOSED] DrillDown Error in Page Designer

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

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,


WebFOCUS 8
Windows, All Outputs
October 11, 2018, 09:59 AM
Fernando
Try changing

FOCEXEC=supplychain_reports/podetaildrdwnsup.fex(

to

FOCEXEC=IBFS:/WFC/supplychain_reports/podetaildrdwnsup.fex(

Fernando


Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
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


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats