Focal Point
[SOLVED] Calling HTM file from Fex

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

April 29, 2010, 10:54 AM
Anmol
[SOLVED] Calling HTM file from Fex
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
April 29, 2010, 11:06 AM
Francis Mariani
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
April 29, 2010, 11:11 AM
Anmol
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
April 29, 2010, 11:39 AM
Francis Mariani
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
April 29, 2010, 11:55 AM
Anmol
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
April 29, 2010, 12:05 PM
Francis Mariani
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
April 29, 2010, 12:15 PM
Anmol
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
April 29, 2010, 01:03 PM
Francis Mariani
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
April 30, 2010, 12:07 AM
Anmol
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