2,340
Hi All,
In my ssrs report print destination I have selected email and selected the Microsoft Excel format. I am able to get the mail but the file name with *.xlsx it is not opening in my system. If the file is in .xls it is opening good. How to change the extension format. Please suggest
*This post is locked for comments
Hello All,
when you select print destination "File" you can specify format "Excel" and file name extension XLS or XLSX. System will automatically generate the Excel-file using needed format.
But when you select destination "Email" and format "Excel" the system will use temporary file name "xxx.tmp". Because of this it will use the most newest version of Excel XLSX (if supported). If you want to get XLS format for the email attachment than you need update the code here: \Classes\SrsReportRunPrinter\toEmail
Hi Denis,
In production SSRS 2012 using, In UAT 2008 R2 using. After importing database from production to UAT the problem occurred. After changing rsreportserver.config file it still showing .xlsx only.
Please suggest what are the areas I need to change and what are the services need to restart.
Hi Denis
I am using Sql server 2008 R2, the rsreportserver.config have following two extensions
<Extension Name="EXCELOPENXML" Type="Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.ExcelOpenXmlRenderer,Microsoft.ReportingServices.ExcelRendering"/>
<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false" />
while executing ssrs report the file name showing with .xlsx format after click on "Ok" button it showing the following error.
You have attempted to use a rendering extension that is either not registered for this report server or it is not supported in this edition of Reporting Services.
where the .xlsx file extension coming from. Is it possible to change this format?
Hi Nagaraj
What SQL Server Reporting Server version you are using ?
With SSRS 2012/2014 the file name extension of files generated by this renderer is xlsx.
With SSRS 2008 R2, the file name extension of files generated by this renderer is xls.
More info at technet.microsoft.com/.../dd239307(v=sql.110).aspx, Export Formats section.
This mean also that you trying to open a XLSX file with an old version of Excel.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (