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,

What does this variable evaluate to? What is the URL this code creates?

This code creates following URL

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

Try changing the %23 to # in the fex.

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.

This is a different problem. You never mentioned this error before.

Post the styling code between

[code]

[/code]

please.

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

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).

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.....


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

Anmol....