Hi,

I have one of my reports creating a hold file which is a dbase file.
Since I can not use PCHOLD to save the file to the local machine of the user running the report, I would like to create a url giving him the possibility to download the file.
My hold file is under 'D:\IBI\APPS\CINVOICE.DBF'
I tried the following URL 'http:\\10.11.136.34:6206\approot\cinvoice.dbf' but it does not work.

Could you please help me solve this issue.

Regards.

Majid.

Majid,
I suppose that your WebFocus server is on 10.11.136.34 with port 6206.
Could it be that you are using backslashes instead of slashes?

Hi Danny,


I noticed that and I have corrected It. But the issue is that now instead of prompting for the location it just open it in the explorer.
I am interested in saving this file on the user computer.

Thanks

Majid,
If your browser opens the DBF file that means that it is allowed to do so. It recognizes the DBF extension and uses the your dbase program to open it. The same happens in Word, for example.

If you want your user to have the option "Open" or "Save" I think you will have to change something in his browser.

Check in Tools->Internet->Security.

Hi Danny,

I am sure that my IE is setup Correctly and I have verified that.
What i wanted to achieve by this is to create a hold file on a machine which is different from webfocus like for example the machine of the user running the report.

Regards

Majid Jeddi

Is your Web Server and the WebFOCUS Reporting Server on the same physical box?

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.

Hi,

Thanks to all of you.

I solved the issue this way:
Once the hold file is created on the WF server i add this at the end of the fex file:

-HTMLFORM BEGIN

Download


-HTMLFORM END

This way the user can download the file wherever he/she wants.

Regrads

FYI if thie application is for a single user no problem. if it is for multiple user you may want to add a date time to the file name. this way they will not overwrite each others file