Hi,

Reportcaster distributing report at 5:00 O'clock morning and output file is either *.XLS or *.PDF.

Distribution Location is a File Sever (Windows)
My Organization wants me to keep This JOB into a Temporary folder (@ Destination) untill it gets fully loaded with data with *.tmp extension. Once it gets all data they want me to move this file to ready folder(@ Destination) with extension *.XLS or *.PDF.

My questions are

(1) While File being distributed into Location Server - Can we keep File extension as *.tmp (or something else)
(2)Once It gets all data (Fully Loaded) would it possible to change extension to *.XLS or *.PDF
(3)If Above mentioned (1) and (2) is not possible then ,can we move Fully Loaded file from Folder X to Folder Y @ Destination Server

Please guide in this issue

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

You can do all of that, but not with ReportCaster functions. I think your only option for something like that would be to create your own script or batch file and execute it as a post-processing procedure. RC only know how to take one output file and put it one place with one name (taking bursting into account.)

I'm not sure if this will help you, but I have a job that runs in reportcaster and creates an excel file then once it is completes I have another that copies the file to a differnt location/with the date and then deletes the old one. This job is run in reportcaster also...

COPY \\CORP\SAHQ_GROUP\TRANS\DEMURRAGE\GRAPHS\DEMGRAPH1.xls \\CORP\SAHQ_GROUP\TRANS\DEMURRAGE\GRAPHS\DEMGRAPHx&MDYY...xls
NT DEL \\CORP\SAHQ_GROUP\TRANS\DEMURRAGE\GRAPHS\DEMGRAPH1.xls

Prarie:

Are you copying and deleting file at Destination Server - Location.?

Can you please explain me little more how we can do through WebFOCUS?

While creating Schedules in Report Caster, make use of Post-processing Procedures option available in Advanced Task Options.

Once main report FEX gets completed, in the Post-processing FEX move the generated report output to different folder.

I believe I need to create another *.fex file which will copy from floder X to folder Y.

For this I need to write DOS command in my *.fex. (above mentioned as Prarie's note)

Right?

If so
please guide me , how to write DOS command in *.fex?

It's fairly easy. Just use the -DOS command:

-DOS mycommand

If "mycommand" involves quite a bit of different operations, you can decide to create a batch file with all of the commands inside and pass some parameters to it so it knows what to do:

-DOS C:\MySCripts\MoveFolder.bat Caster_Folder

That assumes that you have a "Caster_Folder" where your reports are being distributed, and that the MoveFolder.bat script "knows" how to move/copy files located in %1 (Caster_Folder in this example) to a different location.

Thanks all and specially njsden