Copy EXCEL Render extension in SSRS

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"/>
SURESH0518Asked:
Who is Participating?
 
ValentinoVConnect With a Mentor BI ConsultantCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.