May 24, 2013 at 3:42 am
Hello,
I have previously been using SQL Reporting Service 2008 R2. We have now switched over to SQL Reporting Services 2012. When a user goes to run a report then go to save in Excel format, they get the message: Do you want to save or open report.xlsl
However in 2008, we get the message that users can save in xls format. Is it possible to default users to be able to save in xls format in SQL 2012 Reporting Services.
Regards
May 24, 2013 at 7:13 am
It is indeed.
Open up your reporting server config file and open it in a text editor.
It's usually located somewhere like
C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config
Find the line:
<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false"/>
and remove the Visible="false" part.
You should then get a renderer on your list called Excel 2003 which exports xls files and enjoy all the wonderment of 2003.
For more info look up Rendering Extensions in BOL.
May 24, 2013 at 7:18 am
Thank you :))))
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply