...
When OfficeWriter for Reporting Services is installed, there are default names for the OfficeWriter Excel and Word export options: Excel designed by OfficeWriter and Word designed by OfficeWriter.
This post covers how to change these labels to custom values. This approach will work with any of the rendering extensions - not just OfficeWriter.
Steps
These instructions assume that OfficeWriter for Reporting Services is installed. Instructions for installing the Reporting Services integration are available in our documentation: http://wiki.softartisans.com/display/RS8/OfficeWriter Installation.
1. Go to <MS SQL Directory>Go to <MS SQL Directory>\Reporting Services\Report Server.
2. Open Open RSReportServer.config.
3. Locate Locate the ExcelWriter or WordWriter rendering extension declaration in the files <Render> nodefiles <Render> node. If you have OfficeWriter for Reporting Services installed, there will be extensions for "XLTemplate" and "WordTemplate":4. Add
Code Block |
---|
<Configuration>
<Extensions>
<Render>
<Extension Name="XLTemplate" Type="SoftArtisans.OfficeWriter.ReportingServices.ExcelTemplateRenderer, SoftArtisans.OfficeWriter.RS2008" />
<Extension Name="WordTemplate" Type="SoftArtisans.OfficeWriter.ReportingServices.WordTemplateRenderer, SoftArtisans.OfficeWriter.RS2008" />
</ Render>
</ Extensions>
</ Configuration>
|
4. Add the following snippet to override the default extension name with your own custom label: My custom nameNote: The
Code Block |
---|
<OverrideNames>
<Name Language="en-US">My custom name
</Name>
</OverrideNames>
|
*Note:*The language attribute must be set with a language value that is valid on the report server computer. If not, any custom name specified will be ignored. In this example, Reporting Services is running on an English operating system, so the language value is "en-US".
5. When When you are done, the extension declarations should look like this:
Custom ExcelWriter Name
Custom WordWriter Name
...
Code Block |
---|
<Extension Name="XLTemplate" Type="SoftArtisans.OfficeWriter.ReportingServices.ExcelTemplateRenderer, SoftArtisans.OfficeWriter.RS2008" >
<OverrideNames>
<Name Language="en-US">Custom ExcelWriter Name
</Name>
</OverrideNames>
</Extension>
<Extension Name="WordTemplate" Type="SoftArtisans.OfficeWriter.ReportingServices.WordTemplateRenderer, SoftArtisans.OfficeWriter.RS2008" >
<OverrideNames>
<Name Language="en-US">Custom WordWriter Name
</Name>
</OverrideNames>
</Extension>
|
6.Save the file and restart Reporting Services for the changes to take effect.
The names should be the custom names specified in the config file:
For more information, please refer to the following MS SQL Server Tech Net article: http://technet.microsoft.com/en-us/library/ms156281.aspx.