Hi everyone.
Has anyone faced with the problem:
The report is set to schedule (mailing each day format Excel)
Question: Is it possible to change the name of the Report (automatically) during send e-mail and insert [current date] into filename.
For example: format: Name_ [Date] _XX, result: Name_09.08.2013_XX.
Couple of Questions:
Is this a List report or crosstab?
Do you have the ability to set up "write to a file system"?
I cannot find a way to make it so your Excel output gets Date appended to it... sorry... even though Cognos does this when you save Excel versions...
However if you can set up write to a file system - which is usually why people want Excel names with dates so when they copy the excel file from an email into a shared folder it doesn't over write the previous days report.
You can create a Data Item within your query to pull back Current_Date - then you set up burst key on this Current_Date
Then set the schedule to run the burst daily, just make sure you Deselect the "Save Report" and select the "Save report to a File system"
This will create 2 files per day:
Report name is "My Burst Test"
My Burst test-en-us-2013-08-09T00_3A00_3A00.000.xlsx
My Burst test-en-us-2013-08-09T00_3A00_3A00.000-xlsx_desc.xml
There may be a way to turn off the xml file I didn't dig to deeply there.
Nor have I found a way to remove the "-en-es" or the empty time stamp - but the date is there :) You may be able to mess around with and trim it down.