Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1040
  • Last Modified:

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"/>
0
SURESH0518
Asked:
SURESH0518
1 Solution
 
ValentinoVBI 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

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now