Post reply

SSRS 2012 - Dynamically generate report name when exporting a report to excel

  • October 16, 2013 at 9:22 am

    #395676

    Is it possible to dynamically generate a file name at runtime when exporting a report to Excel in SSRS 2012? Currently the export is always named report.name.xlsx. Our users would like us to differentiate the file name for each export by adding the execution timestamp. They prefer to avoid typing a new file name for each export.

    I thought I might be possible to use an expression based on the Global!RenderFormat.Name condition to set a dynamic report name. I have not been able to locate the ReportName property.

    Any help will be greatly appreciated.

  • October 17, 2013 at 4:47 am

    #1659215

    You could do that with subscriptions.

  • October 17, 2013 at 6:26 am

    #1659280

    Check this[/url] out.

  • October 18, 2013 at 8:04 pm

    #1659878

    Scott,

    Thanks that would work, but our users want this capability on the fly. I haven't seen anything that leads me we can do that from the report definition.

    We are looking at setting the file name using the Report Viewer control. Hopefully that will work.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply