Focal Point
FOCEXEC with SET FOCEXURL

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

February 24, 2016, 08:45 AM
SWES
FOCEXEC with SET FOCEXURL
Hi,

I'm having a fex in domain 'B' which uses SET FOCEXURL = /ibi_apps/WFServlet to open a fex in domain 'A' via an INCLUDE. This works fine. The INCLUDE fex has a FOCEXEC to open a fex also residing in domain 'A'. However, i get the FOC 227 Procedure not found error when opening the FOCEXEC.

Question is: how can I combine the FOCEXEC command with the SET FOCEXURL needed?

ps. still on version 7, not 8

Thanks,
SWES


WebFOCUS 8105m
Windows 7, All Outputs

Member of the Benelux Usergroup
February 24, 2016, 08:55 AM
BabakNYC
This might be a shot in the dark but have you tried:
-MRNOEDIT INCLUDE focexec


WebFOCUS 8206, Unix, Windows
February 24, 2016, 10:25 AM
Francis Mariani
-MRNOEDIT -INCLUDE is used to include fex files that are located on the reporting server.

SET FOCEXURL is used to set up the location of the WebFOCUS Servlet and is used in fex files that have drill-downs, so that the drill-downs work properly - particularly useful for PDF and Excel reports.

In your main fex, you have SET FOCEXURL and -INCLUDE - I don't see how SET FOCEXURL helps you to use -INCLUDE to include a fex file located in another domain.

I don't have WF 7 any more so I can't verify, but have you tried -INCLUDE domain-name/app/fex-name.fex ?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 26, 2016, 09:17 AM
SWES
Thank you for your suggestion Babak, its what came to mind to me as well, but unfortunately no cigar.

Francis, I don't see how SET FOCEXURL helps me either, but it works with it, so all fine by me.

The problem is:

 $
TYPE=DATA,
	 COLUMN=TEST,
     FOCEXEC=app/drilldown.fex( A=A B=B ), 


I cannot put it like this:

 $
TYPE=DATA,
	 COLUMN=TEST,
-INCLUDE FOCEXEC=app/drilldown.fex( A=A B=B ), 


It's not how the stylesheet works I guess... but the trouble is there with the FOCEXEC.


WebFOCUS 8105m
Windows 7, All Outputs

Member of the Benelux Usergroup
February 29, 2016, 08:11 AM
Ricardo Augusto
Why do you want INCLUDE a fex to perform a drill down?


WebFOCUS 8.1.05 / APP Studio
February 29, 2016, 09:11 AM
Francis Mariani
Either you're not explaining things correctly or you're not doing things correctly.

1) It appears you DO NOT have an include, but rather, a drill-down (that second form of stylesheet drilldown is definitely not correct.

2) Please try:

TYPE=DATA,
COLUMN=TEST,
FOCEXEC=domain-name/app/fex-name.fex ( A=A B=B ), $



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server