Share via

Including time stamp in subscription report file name

  • Article

Operations Manager Report subscription wizard asks you to specify a File Name when you choose Windows File Share delivery method. In most cases where you just need to have a most recent report delivered to the share you would just type a desired name in the field and look for the result then the time comes. If you would like to keep the history though, you would probably want to include something like a time stamp in the file name to keep the names unique and prevent reporting server overriding the results every time a new report is generated. To do the trick you can add  @timestamp variable to the File name. For example: Report@timestamp. The resulted file name will look something like Report2009_10_05_000000 which would not only allow you to keep the names unique but would also give everyone an immediate idea on when the file was generated.

Read more about File Share Delivery in SQL Reporting Services documentation.

Comments

  • Anonymous
    November 08, 2010
    How do you add different parameters (inside the report) i.e. @RunDate  (inside the File name) rather than @timestamp ?

  • Anonymous
    November 08, 2010
    @timestamp is the only variable allowed in in the subscription file names. You can read more about it here: msdn.microsoft.com/.../ms159264(SQL.90).aspx If you want to change the way name is generated your best alternative is probably creating a data driven subscription. We do not support them in SCOM console but you can create in manage them directly in SSRS Report Manager. Here you can fine more information about Data Driven subscriptions: msdn.microsoft.com/.../ms159150(SQL.90).aspx

  • Anonymous
    November 20, 2012
    How do you get the FileName from the ReportServer Database that is being Subscribed as ReportName@timestamp. I wanted to know the Actual File Name that gets stored in the Windows Network shared location. If you Query the Subsriptions Table then we will be getting the FileName as ReportName@timestamp.

  • Anonymous
    November 28, 2012
    Hi Balram, Have a look at the catalog table in reportserver.