web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Way to append date to ...
Microsoft Dynamics CRM (Archived)

Way to append date to report

(0) ShareShare
ReportReport
Posted on by Community Member

I have several scheduled reports that are delivered in Excel format and would like to be able to have the date in the filename. Is that possible? I looked through the options in both CRM and the Report Server and couldn't seem to find anything.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Royal King Profile Picture
    Royal King 27,686 on at

    To do date to file name append @timestamp variable to the File name. For example: Report@timestamp. The resulted file name will look something like Report2009_10_05_000000.

    You can find more detail on the same here

    http://msdn.microsoft.com/en-us/library/ms159264(SQL.90).aspx

  • Community Member Profile Picture
    Community Member on at

    Is this done from the Report Server or from SQL Server?

  • Royal King Profile Picture
    Royal King 27,686 on at

    Report server.

  • Community Member Profile Picture
    Community Member on at

    Is that only an option if the report is delivered by Windows File Share? My reports are delivered via email and I don't see an option in the Report Delivery Options for file name.

  • Royal King Profile Picture
    Royal King 27,686 on at

    Yes this option available only for windows file share option. By default report server adds execution time in the email subject  using that user should be able to determine date of the report.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans