Focal Point
How to dynamically assign name when the report is distribued to a FTP server

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8241097331

August 09, 2004, 02:33 PM
<kj>
How to dynamically assign name when the report is distribued to a FTP server
Is there a way to assign dynamic report name when the report is distributed to an FTP server using Report Caster?
My report is scheduled every month and I want to add Month & Year when it is saved in ftp server.

Any help is greatly appreciated.

I am using WF 5.2 on Win 2k.

Thanks,
kj.
August 23, 2004, 02:41 AM
TexasStingray
Cool Report Caster Supports a file for the distribution list. I would create a procedure that create the distribution list(file). This file needs to be available to the Distribution Server (Report Caster). Then I would schedule this procedure to run some time before the actual procedure so that it has enough time to complete. Then have the actual procedure use this list instead of an internal list.
August 23, 2004, 03:26 PM
<Pietro De Santis>
KJ, I assume you mean the physical file name of the report. I haven't done this, but I think you could simply execute a FILEDEF before creating the report and then in the HOLD command, mention the file name:

-SET &OUT_FILE= 'C:\TEMP\' || 'RPT' || &YEAR || &MONTH;

FILEDEF RPT DISK &OUT_FILE
-RUN

ON TABLE HOLD AS RPT FORMAT HTML