Where to change the SSRS report print destination excel format?

(0) Share

Report

Posted on by nagaraj

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

I have the same question (0)

All responses (5)

Answers (0)

taral13 10 on at

Like (0)

Report

RE: Where to change the SSRS report print destination excel format?

But what if i want to send my attachment with .xlsx format?

what code i have to exactly change?

Was this reply helpful? Yes No
Suggested answer

Dmitry Begun 20 on at

Like (1)

Report

RE: Where to change the SSRS report print destination excel format?

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

Was this reply helpful? Yes No
nagaraj 2,340 on at

Like (0)

Report

RE: Where to change the SSRS report print destination excel format?

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.

Was this reply helpful? Yes No
nagaraj 2,340 on at

Like (0)

Report

RE: Where to change the SSRS report print destination excel format?

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?

Was this reply helpful? Yes No
Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report

RE: Where to change the SSRS report print destination excel 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.

Was this reply helpful? Yes No