Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS 2012 - Dynamically generate report name when exporting a report to excel Expand / Collapse
Author
Message
Posted Wednesday, October 16, 2013 9:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, December 22, 2014 2:44 PM
Points: 125, Visits: 278
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.

Post #1505295
Posted Thursday, October 17, 2013 4:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 6:14 AM
Points: 243, Visits: 2,758
You could do that with subscriptions.
Post #1505588
Posted Thursday, October 17, 2013 6:26 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, December 12, 2014 6:22 AM
Points: 531, Visits: 449
Check this out.
Post #1505665
Posted Friday, October 18, 2013 8:04 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, December 22, 2014 2:44 PM
Points: 125, Visits: 278
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.
Post #1506356
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse