I would like to include a date at the end of a file name. I have a weekly report (distributed via email) that will generate the same file name over again.
This is problematic as I would like to store the files in the same folder, but cannot if the names are not differentiated by a date.
I could manually put the date in every time I move the file to the shared drive, but I think there MUST be a way for reportcaster to do this for me.
I am using Webfocus Version: 7702
That would be a function within your FEX, not sure that RC has that ability. try to create the final file, appended with a date, within your fex.
Do something like:
-SET &reportname = 'report' || &DATE; TABLE FILE CAR PRINT CAR ON TABLE SET PAGE-NUM NOLEAD ON TABLE PCHOLD AS &reportname FORMAT EXL2K END
Note that you may need to set your redirection settings and set save to yes for exl2k or whatever your format. &DATE is populated by default. to see other variables you can use, do:
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
We do something like this
HIDDEN_SORT/I9 = &YSTRDY0;
ON TABLE PCHOLD FORMAT EXL2K
Set the RC Schedule to BURST the report.
Windows NT-5.2 x86 32bit
There are some other options
- Report library, to save the file in several versions
- save the file direct in the folder without a mail.
|Powered by Social Strata|