Hi,

I need to save an EXL output in a network folder.for this i use APP MAP and filedef both of which are not working.can any1 specify a working example.thanks in advance

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

Need more info, Saggy. Where is the reporting server, Windows or Unix? If on the latter, you might have to do a Samba share and the APP MAP and filedef.

If on Windows, you do have the correct permissions?

So please explain your architecture in a bit more detail.

Yes Ginny the Reporting server is in UNIX
but the file has to be saved on a machine having windows.
You were talking of permissions on windows.so what permissions were you reffering to .

I have my procedure which creates the EXL in the MRE of reporting server which is on UNIX.

let me know what other details u want

Well, that's enough. But you'll have to check with your admin to see how to share windows drives on Unix. We use Samba Share.

Or save locally to the Unix box and then FTP.

T

We do this exact thing from a UNIX server (WF Re[porting Server) to a Windows server (web server). My programs perform a UNIX copy from edatemp to a directory on the UNIX box and then it executes a stored procedure, which was written by our DBA, to ftp the excel file over to the windows server. Here's an example of the copy and the call to the stored procedure. Hope it helps.

  
-SET &ARGLEN = ARGLEN(120,TEMPPATH(120,'A120'),'I2')+1;
-SET &TP    = TEMPPATH( &ARGLEN, 'A&ARGLEN.EVAL') || '&EFILE';

UNIX cp &TP.EVAL /webfocus/asnrecap.xls

ENGINE SQLMSS SET DEFAULT_CONNECTION DBNAME
-RUN

SQL SQLMSS
EX MSDB.dbo.sp_start_job N'FTPGetFromWebFocus filename'
END
-EXIT

thanks a ton to all got this solved by the IBI.