Hi all,

i scheudled a report in report caster to run monthly in xls format and ftp the file to a location as the report is huge size.
When the new report is generated, it is replacing the already existing report in the specified location. but we need old reports also available in the location

can someone plz let me know is it poosible to append current date/time to the filename or create different folders for eachtime file is created in report caser.

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

Name your file as "filename_&YYMD". At run time the current date will be appended to your file name.

If you are running this procedure more than once/day, append the &TOD variable:
filename_&YYMD._&TOD

Thanks all for reply.

i have one more question. there is a file in a file share location (\\vfile01\ctm\files\). Is there a way to rename the file in that location ??

Sure. Use the ! ("bang") and issue your rename command. In your case (unix? linux?):
!mv old-file-name new-file-name

You will need write permission.

You can run operating system commands from within a FEX in the form of -[OP System) [any command]. So, for UNIX:
-UNIX mv [options] oldfilename newfilename

As Report Caster will only do one file/report in one schedule, I generally write my own sftp/ftp scripts and use the -UNIX . script_nm do to the sftp/ftp. The advantage here is if you have a job stream that has numerous steps that create numerous outputs, you can have one RC job and do the sftp/ftp at the end. RC may object because there is no output to distribute there are ways around that as well.