Solved

Copy EXCEL Render extension in SSRS

Posted on 2014-02-12
1
964 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

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

809 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