Hi,

Yes they are.

Thanks

Majid,

If you want output from a WebFOCUS report to appear on another server, different from the one executing the *.fex, then I suggest using DOS and FTP.
Of course, the receiving server must have an FTP service available.

The FOCUS procedure performs 3 steps:
1) TABLE FILE ... END produces the report in whatever form you like to either the agent's temporary space, or to pre-allocated space on the same server.
1a) If in agent space, use Dialogue manager to construct the fully qualified path and name of the output beginning with TEMPPATH(40,'A40').
1b) If in allocated space, use FILEDEF to path and name the report into a directory on one of the sever's labeled drives.

2) Use FILEDEF and WRITE to prepare a (temporary) file containing the commands necessary to 'drive' an FTP session.

3) Use the wonderful ability of the FOCUS procedure language to contain imbedded DOS commands and insert "DOS FTP ...." into your *.fex.

Using the agent space option, your procedure will look something like this for an Excel report:

 
-SET &REPORT_PATH = TEMPPATH(40,'A40')||'\REPORT.xls'
TABLE FILE 
...
ON TABLE HOLD AS REPORT FORMAT EXL2K
END
-RUN

FILEDEF FTPCMDS DISK E:\IBI\APPS\...\FTPCMDS.FTP
-RUN
-WRITE FTPCMDSP open <ftptargetservice>
-WRITE FTPCMDS <ftpuserid>
-WRITE FTPCMDS <ftppassword>
-WRITE FTPCMDS <... other commands as needed ...>
-WRITE FTPCMDSP put &REPORT_PATH
-WRITE FTPCMDSP close
-WRITE FTPCMDS bye
-RUN

DOS ftp -i -s:E:\IBI\APPS\...\FTPCMDS.FTP
-RUN
 

If run in RCaster, use the FTP output option instead of the method shown above.

Set-up a WebServer on the target server so that it will operate the URL you need and display the report you sent to that server.

This can be coded in DevStudio, with the report portion done in Report Assist/Painter and the rest as Comments.
(This is where I like to drop the DevStudio tool and pick-up Edit-Text.)

Chris

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

Ok, sence they are on the same box I would create a simple file something like test.html and see of I can access it from a browser. if the file is on ibi\apps in my url i would try

http://xxxxxxx/approot/test.html

if that worked rename the file changing the extention that that which to want. and try accessing it again.

if that worked then retry you file just from a browser. if that does not work then it looks like it might be a security issue. try creating a folder under apps called temp meove the file there, try it again from a browser changing the url to something like

http://xxxxxxx/approot/temp/yyyyy.zzz

changing the xxx's yyy's and zzzz's to call your file

PS just incase make sure you are using the correct case upper/lower

Hope this helps.