Schedule report attachment should appended with execution date

[SGD]

Hi,

I have scheduled a Report studio report which goes to recipients in an Excel 2007 format. This is weekly schedule report which executes every Monday and it works as expected.

Now, my client wants to see execution date appended after report attachment name. e.g. 'Train Consist AoA Weekly Report_19122011'

I have found one solution in IBM site (https://www.ibm.com/developerworks/forums/thread.jspa?messageID=14459475&#14459475) which appends execution date for 'Mail Subject' & 'Mail Body' part but not for 'mail attachment'.

Could anyone suggest how should I achieve this requirement?

[SGD]

Any solution? I am still struggling to achieve this functionality.  ???

[SGD]

Just pushing this post on top for Gurus attention...

[CognosPaul]

From what I've heard, this is possible with the SDK, but I lack the experience to give an example.

Through vanilla Cognos, your options are somewhat limited. You can schedule reports to save to the file system with date appended to the file. You could also use Event Studio to send the report, and put the date in the subject of the email.

[Pranav]

I am also looking for answer to same question..i need to send report output to a site  ( i know we can get date time stamp by writting report to file location)

[CognosPaul]

Another possible solution - you can use Event Studio, with the event as 1=1 or something similar, as a scheduling tool to append the date to the subject line of the email. It doesn't alter the file name, but it gets a result closer to what you need.