how to make export file name dynamic

Is it possible to specify the file name of exported file? We like to have
certain naming convention, including timestamp.I believe you can change the DisplayName property to get what you want. I
have noticed the exported file name is based on the DisplayName attribute of
the report, but I have only done this with ReportViewer control. Lookup this
property under the reporting service documentation.
Good luck,
Jeff
"Jason Wang" wrote:
> Is it possible to specify the file name of exported file? We like to have
> certain naming convention, including timestamp.|||On Apr 30, 5:50 pm, Jeff Tu <Jef...@.discussions.microsoft.com> wrote:
> I believe you can change the DisplayName property to get what you want. I
> have noticed the exported file name is based on the DisplayName attribute of
> the report, but I have only done this with ReportViewer control. Lookup this
> property under the reporting service documentation.
> Good luck,
> Jeff
> "Jason Wang" wrote:
> > Is it possible to specify the file name of exported file? We like to have
> > certain naming convention, including timestamp.
As far as I know, there's not really any control over this. I would
suggest using a follow behind stored procedure that uses:
EXEC xp_cmdshell 'rename OriginalReportName.rdl
NewReportName043007_0930.rdl'
Ofcourse, this would need to be called after the report was saved.
Sorry I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thank you for your replies.
Is it possible to do it in Delivery Extension? If possible, how hard will it
be?
"EMartinez" wrote:
> On Apr 30, 5:50 pm, Jeff Tu <Jef...@.discussions.microsoft.com> wrote:
> > I believe you can change the DisplayName property to get what you want. I
> > have noticed the exported file name is based on the DisplayName attribute of
> > the report, but I have only done this with ReportViewer control. Lookup this
> > property under the reporting service documentation.
> >
> > Good luck,
> > Jeff
> >
> > "Jason Wang" wrote:
> > > Is it possible to specify the file name of exported file? We like to have
> > > certain naming convention, including timestamp.
>
> As far as I know, there's not really any control over this. I would
> suggest using a follow behind stored procedure that uses:
> EXEC xp_cmdshell 'rename OriginalReportName.rdl
> NewReportName043007_0930.rdl'
> Ofcourse, this would need to be called after the report was saved.
> Sorry I could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>