Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Calling HTM file from Fex

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Calling HTM file from Fex
 Login/Join
 
Gold member
posted
HI all,
WE have recently migrated to a new structure in our application i.e all HTM files reside in MRE
and all corresponding FEX files would reside in EDASERVE.
Everything works fine now, except one problem which I am stuck into this..
From the hyperlink of output of one of my HTML output I am calling a another HTM files,
as this HTM files is in MRE it somehow not working.
Here is code which i was trying in the Fex file
 
-SET &HOSTSTR = 'http://&SERVERNM:&PORTNO/ibi_apps/WFServlet?IBIMR_action=MR_RUN_FEX&|IBIMR_sub_action=MR_STD_REPORT&|IBIMR_drill=RUNNID&|IBIMR_fex=app/ThisIsMyHtmFile.htm&|IBIMR_folder=%23&FOLDERNAME&|IBIMR_domain=&DOMNAME/&DOMNAME.htm';
 


Same URL runs when i directly paste in browser,but this is not working from the fex file.
Does someone has worked?please suggest
any help would be highly appreciated..

Thanks.

This message has been edited. Last edited by: Kerry,


WebFocus7.6.2, WebFocus 7.1.1,Windows
HTML, PDF and Excel
 
Posts: 71 | Registered: June 30, 2009Report This Post
Expert
posted Hide Post
What does this variable evaluate to? What is the URL this code creates?


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Gold member
posted Hide Post
This code creates following URL

http://itaccdbos1:32000/ibi_ap...taacudt/itaacudt.htm]


WebFocus7.6.2, WebFocus 7.1.1,Windows
HTML, PDF and Excel
 
Posts: 71 | Registered: June 30, 2009Report This Post
Expert
posted Hide Post
Try changing the %23 to # in the 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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Gold member
posted Hide Post
That also doesn't help Francis...
getting following error

(FOC3202) BAD VALUE IN STYLESHEET FILE

as previous one....
any other suggestion please??
thanks in advance.


WebFocus7.6.2, WebFocus 7.1.1,Windows
HTML, PDF and Excel
 
Posts: 71 | Registered: June 30, 2009Report This Post
Expert
posted Hide Post
This is a different problem. You never mentioned this error before.

Post the styling code between
[code]
[/code]
please.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Gold member
posted Hide Post
Here is code Francis. Sorry for the confusion....
TYPE=REPORT,BORDER=LIGHT,FONT='ARIAL',SIZE=9,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,$

-SET &HOSTSTR = 'http://itaccdbos2:32000/ibi_apps/WFServlet?IBIMR_action=MR_RUN_FEX&|IBIMR_sub_action=MR_STD_REPORT&|IBIMR_drill=RUNNID&|IBIMR_fex=app/ThisIsMyHtmFile.htm&|IBIMR_folder=%23itaacdit2jmg&|IBIMR_domain=itaacdit/itaacdit.htm';
TYPE=DATA,COLUMN=TAAC_CODE,URL=&HOSTSTR,TARGET='_blank',$
ENDSTYLE
END



Thanks.
anmol


WebFocus7.6.2, WebFocus 7.1.1,Windows
HTML, PDF and Excel
 
Posts: 71 | Registered: June 30, 2009Report This Post
Expert
posted Hide Post
You have to split the URL up into multiple parts, it's too long ans must span more than one line. The best way to do this is to NOT build a single variable that contains the whole URL, but separate it into individual parameters, one per line:

-SET &ECHO=ALL;

-DEFAULT &MR_fex    = 'app/testrepo.htm';
-DEFAULT &MR_folder = '#testyrsaxhlg';
-DEFAULT &MR_domain = 'francism/francism.htm';

TABLE FILE CAR
SUM
SALES
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=COUNTRY,
-*URL=http://xxxyyy666777.prod.net:8080/ibi_apps/WFServlet?( \
URL=/ibi_apps/WFServlet?( \
IBIMR_action     = 'MR_RUN_FEX' \
IBIMR_sub_action = 'MR_STD_REPORT' \
IBIMR_drill      = 'RUNNID' \
IBIMR_fex        = '&MR_fex' \
IBIMR_folder     = '&MR_folder' \
IBIMR_domain     = '&MR_domain' ),
TARGET='_blank', $
ENDSTYLE
END
-RUN


If the server is the same as where the fex is executed you can use the shorter URL (without server name), if it's on a different server, use the longer URL (with server name).


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Gold member
posted Hide Post
Tons of Thanks Francis for your trick...!!
It works very well......
I tried every possible option,but I didn't thought of the option suggested by you......

My Report is running very fast now..... Smiler


Credit is to you Francis........
Thanks again.....
Greatly appreciates you !!!!

Anmol....


WebFocus7.6.2, WebFocus 7.1.1,Windows
HTML, PDF and Excel
 
Posts: 71 | Registered: June 30, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Calling HTM file from Fex

Copyright © 1996-2020 Information Builders