Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How to dynamically assign name when the report is distribued to a FTP server
Go
New
Search
Notify
Tools
Reply
  
How to dynamically assign name when the report is distribued to a FTP server
 Login/Join
 
<kj>
posted
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.
 
Reply With QuoteReport This Post
Master
posted Hide Post
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.
 
Posts: 862 | Registered: May 24, 2004Reply With QuoteReport This Post
<Pietro De Santis>
posted
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
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How to dynamically assign name when the report is distribued to a FTP server

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.