March 31, 2009 at 7:04 am
Hi All,
I've created a report in SSRS 2005 and added a report subscription so that I can get the report output in the form of a CSV file according to a predefined schedule. The CSV file is getting created fine. But, the project requirement specifies that the current date be appended to CSV filename and the name should be in the format [filename]_YYYYMMDD.csv where YYYYMMDD is the date format.
I had tried specifying the name of the csv file as
[filename]_@timestamp while creating the report subscription. But this appends the date in the format MM_DD_YYYY_HH_MIN_SS to the filename. I have searched the net for a solution but could not come across any plausible one. I would be greatful to someone who can find a way around.
Thanks in advance.
March 31, 2009 at 9:42 am
I didn't even know you can use parameters for file output names like your @timestamp
If that's the case, is it possible to use either SQL or VB functions to format the date (so CONVERT, etc..)
April 1, 2009 at 9:48 am
Nope...I've tried using SQL Server in-built functions like CONVERT, CAST, etc. but they don't work while specifying output filenames. I think there may be some other parameters (like @timestamp) which can be used for this purpose and I'm still trying to figure them out.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply