I have created a excel workbook and have schedule in report caster and want to distribute it with today's date and time as part of it name. Is this possible?
Thansk

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

Not directly within catser. However, you could write the output to a network file named as you require, and then use something like CDONTS to distribute it for you.

T

If the job is run on a standard schedule where you know what the next run date is just update the BOTTASK table

it can be added as a post-processing procedure

MODIFY FILE BOTTASK
FREEFORM TASKID PACKETID ASVALUE
MATCH TASKID PACKETID
ON MATCH UPDATE ASVALUE
ON NOMATCH REJECT
DATA
'taskid','paketid','fred&YYMD.EVAL.XLS',$
END
-RUN

does the paketid change? if i run this daily what prevents me from updating all prior versions with today's date

No, it's part of the primary key.

Thanks for the help, I'm close but I get a nomatch here is the message, the code I'm using and a sql statement that finds it

(FOC415)TRANS 1 REJECTED NOMATCH SEG01
'T14e3fieq801','P14e3fs6ec02','ssbo_toc_line_data_09082009XLS',$
0 TRANSACTIONS: TOTAL = 1 ACCEPTED= 0 REJECTED= 1
SEGMENTS: INPUT = 0 UPDATED = 0 DELETED = 0


MODIFY FILE BOTTASK
FREEFORM TASKID PACKETID ASVALUE
MATCH TASKID PACKETID
ON MATCH UPDATE ASVALUE
ON NOMATCH REJECT
DATA
'T14e3fieq801','P14e3fs6ec02','ssbo_toc_line_data_&MDYY.XLS',$
END
-RUN



I can find it by using the following sql statement:
select t.*, t.rowid from bottask t where taskid = 'T14e3fieq801' and packetid = 'P14e3fs6ec02'

This doesn't address your current problem, but the one in the wings:

What you have echoes as

...
DATA
'T14e3fieq801','P14e3fs6ec02','ssbo_toc_line_data_09082009XLS',$
END

(The . after &MDYY is taken as a delimiter, if what follows is not an attribute keywork such as LENGTH or EXISTS.)
To make ".XLS" part of the resolved value, add a vertical (or another period) before ".XLS".

Thanks so much..I got it to work