Solved

Copy EXCEL Render extension in SSRS

Posted on 2014-02-12
1
956 Views
Last Modified: 2014-02-25
is it possible to copy current excel render extension to another excel extension and I would like name it as EXCEL for Analysis. I would like to see this an another extension option when running report.

I found this line in rsreportserver.config file. Any help is appreciated.

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="False"/>
0
Comment
Question by:SURESH0518
1 Comment
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39855486
Visible="False" indicates that the EXCEL rendering extension is disabled.  I assume you're running SSRS 2012?  In that version this is indeed the default because it got replaced by a newer version which you'll also find in that same config file:

<Extension Name="EXCELOPENXML" Type="Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.ExcelOpenXmlRenderer,Microsoft.ReportingServices.ExcelRendering"/>

As for your question on "copying" the extension, I don't think it's possible.  You can try by adding the following to the <Render> section:

<Extension Name="EXCEL for Analysis" Type="Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.ExcelOpenXmlRenderer,Microsoft.ReportingServices.ExcelRendering"/>

but even if it works I don't think it will have the effect that you're expecting.  The labels used for the export dropdown are not exposed AFAIK...

PS: I have not tested this out, please ensure you make a backup of the config file before editing it.  Also, you'll need to restart the SSRS service for changes to have effect.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
CRM 2011 Error Connecting to Report Datasource 7 65
SCCM Reporting 5 55
Ssrs disable the home lonk 1 71
SSRS Expression IIF Statements 2 44
Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now