Instead of repeating fexes over domains, most commonly used routines and drill fex are kept in a common folder to maintain clean code.
Solution: Use of -MRNOEDIT to run the common code from EDASERVE and to run common drill fexes from EDASERVE , use of -SET &FOCEXURL to point URL to fex in the common code folder
PROBLEM: PDF reports headings allows user to drill to get an Excel version of the same report. ( It’s drilling with parameters to itself ) It works if all code is in the same domain, but since the common code is now on a separate location, this drill to itself does not work because of the SET &FOCEXURL pointing to different area. Users will access reports via ReportCaster Library, all these report will be in PDF format, this report and others will have a standard drill fexs that will be in the common code folder on EDASERVE and that part works.
How can I get this report to run, after it has been run in the PDF format, but now in an excel format using the same parameters .
Active Report is not available here.
I am trying to create a URL in the heading but it’s not working.. Any help would be appreciated
Thanks
CODE for displaying URL in the heading of PDF report
When I run it, gives the following error
(FOC295) A VALUE IS MISSING FOR: &IBIMR_action
-SET &PATH='http://wfserver/ibi_apps/WFServlet?';
-SET &PATH=&PATH | 'IBIMR_domain=develope/develope.htm' | '&';
-SET &PATH=&PATH | 'IBIMR_folder=#larryg908ioz' | '&';
-SET &PATH=&PATH | 'IBIMR_action=MR_RUN_FEX' | '&';
-SET &PATH=&PATH | 'IBIMR_subaction=MR_STD_REPORT' | '&';
-SET &PATH=&PATH | 'IBIMR_fex=app/fadepsm.fex';
-SET &PATHURL = ''|'Export to Excel';

This message has been edited. Last edited by: <Kathryn Henning>,

-SET &FOCEXURL

SET FOCEXURL = path

 
-SET &URL = &URL_PROTOCOL | '://' | &SERVER_NAME | &FOCEXURL | '&|IBIF_ex=employee/app/employeedetailcompound&|CLICKED_ON=&';