Dear All,
I want to know whether the Reporting Service can implement the
different layout for different export format. e.g. When I get the html
report, I do not need to show condition(paramter) on report. but When I
export the excel report, I want to show the condition(parameter). Can I get
the export format information in reports?
best regards
yazheng_wangThe reports have to be consistent between renderers....
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"yazheng wang" <yazheng wang@.discussions.microsoft.com> wrote in message
news:D3F52C78-3886-47E8-92F5-A0C70D9980BB@.microsoft.com...
> Dear All,
> I want to know whether the Reporting Service can implement the
> different layout for different export format. e.g. When I get the html
> report, I do not need to show condition(paramter) on report. but When I
> export the excel report, I want to show the condition(parameter). Can I
> get
> the export format information in reports?
>
> best regards
> yazheng_wangsql
Showing posts with label export. Show all posts
Showing posts with label export. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
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
>
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
>
Monday, March 12, 2012
How to list (Export to txt) the Built-In and User Store Procedures
Good afternoon,
How can I export a list of Built-In and User Made Stored Procedures on an
SQL-2005 server ?
Regards,
Luis
Hi
How about querying sys.objects? If you want to do this manually save the
output from SSMS or use output option for SQLCMD, or use a query with BCP!
John
"gatox" wrote:
> Good afternoon,
> How can I export a list of Built-In and User Made Stored Procedures on an
> SQL-2005 server ?
> Regards,
> Luis
How can I export a list of Built-In and User Made Stored Procedures on an
SQL-2005 server ?
Regards,
Luis
Hi
How about querying sys.objects? If you want to do this manually save the
output from SSMS or use output option for SQLCMD, or use a query with BCP!
John
"gatox" wrote:
> Good afternoon,
> How can I export a list of Built-In and User Made Stored Procedures on an
> SQL-2005 server ?
> Regards,
> Luis
How to list (Export to txt) the Built-In and User Store Procedures
Good afternoon,
How can I export a list of Built-In and User Made Stored Procedures on an
SQL-2005 server ?
Regards,
LuisHi
How about querying sys.objects? If you want to do this manually save the
output from SSMS or use output option for SQLCMD, or use a query with BCP!
John
"gatox" wrote:
> Good afternoon,
> How can I export a list of Built-In and User Made Stored Procedures on an
> SQL-2005 server ?
> Regards,
> Luis
How can I export a list of Built-In and User Made Stored Procedures on an
SQL-2005 server ?
Regards,
LuisHi
How about querying sys.objects? If you want to do this manually save the
output from SSMS or use output option for SQLCMD, or use a query with BCP!
John
"gatox" wrote:
> Good afternoon,
> How can I export a list of Built-In and User Made Stored Procedures on an
> SQL-2005 server ?
> Regards,
> Luis
How to list (Export to txt) the Built-In and User Store Procedures
Good afternoon,
How can I export a list of Built-In and User Made Stored Procedures on an
SQL-2005 server ?
Regards,
LuisHi
How about querying sys.objects? If you want to do this manually save the
output from SSMS or use output option for SQLCMD, or use a query with BCP!
John
"gatox" wrote:
> Good afternoon,
> How can I export a list of Built-In and User Made Stored Procedures on an
> SQL-2005 server ?
> Regards,
> Luis
How can I export a list of Built-In and User Made Stored Procedures on an
SQL-2005 server ?
Regards,
LuisHi
How about querying sys.objects? If you want to do this manually save the
output from SSMS or use output option for SQLCMD, or use a query with BCP!
John
"gatox" wrote:
> Good afternoon,
> How can I export a list of Built-In and User Made Stored Procedures on an
> SQL-2005 server ?
> Regards,
> Luis
Subscribe to:
Posts (Atom)