Message-ID: <1786496543.7647.1711616834899.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7646_701453218.1711616834899" ------=_Part_7646_701453218.1711616834899 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html How to define custom names for Reporting Services export options=

How to define custom names for Reporting Services export options

Intro

=20

When OfficeWriter for Reporting Services is installed, there are default= names for the OfficeWriter Excel and Word export options: Excel designed b= y OfficeWriter and Word designed by OfficeWriter.

=20

=20

This post covers how to change these labels to custom values. This appro= ach will work with any of the rendering extensions - not just OfficeWriter.=

=20

St= eps

=20

These instructions assume that OfficeWriter for Reporting Services is in= stalled. Instructions for installing the Reporting Services integration are= available in our documentation: Offi= ceWriter Installation.

=20

1. Go to <MS SQL Directory>\Reporting Services\Report Serv= er.
2. Open RSReportServer.config.
3.= Locate the ExcelWriter or WordWriter rendering extension declaration in th= e files <Render> node. If you have OfficeWriter for = Reporting Services installed, there will be extensions for "XLTemplate= " and "WordTemplate":

=20
=20
<Configuration>
        <Extensions>
              <Render>
                    <Extension Name=3D"XLTemplate" Type=3D&quo=
t;SoftArtisans.OfficeWriter.ReportingServices.ExcelTemplateRenderer, SoftAr=
tisans.OfficeWriter.RS2008" />
                    <Extension Name=3D"WordTemplate" Type=3D&q=
uot;SoftArtisans.OfficeWriter.ReportingServices.WordTemplateRenderer, SoftA=
rtisans.OfficeWriter.RS2008" />
              </ Render>
        </ Extensions>
  </ Configuration>
=20
=20

4. Add the following snippet to override the default extension name with= your own custom label:

=20
=20
<OverrideNames>
        <Name Language=3D"en-US">My custom name
        </Name>
  </OverrideNames>
=20
=20

*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 o= perating system, so the language value is "en-US".

=20

5. When you are done, the extension declarations should look like this:<= /p>=20

=20
<Extension Name=3D"XLTemplate" Type=3D"SoftArtisans.Offic=
eWriter.ReportingServices.ExcelTemplateRenderer, SoftArtisans.OfficeWriter.=
RS2008" >
        <OverrideNames>
              <Name Language=3D"en-US">Custom ExcelWriter N=
ame
              </Name>
        </OverrideNames>
  </Extension>

  <Extension Name=3D"WordTemplate" Type=3D"SoftArtisans.O=
fficeWriter.ReportingServices.WordTemplateRenderer, SoftArtisans.OfficeWrit=
er.RS2008" >
        <OverrideNames>
              <Name Language=3D"en-US">Custom WordWriter Na=
me
              </Name>
         </OverrideNames>
  </Extension>
=20
=20

6.Save the file and restart Reporting Services for the changes to take e= ffect.

=20

The names should be the custom names specified in the config file:

= =20

=20

For more information, please refer to the following MS SQL Server Tech N= et article:http://technet.microsoft.com/= en-us/library/ms156281.aspx.

------=_Part_7646_701453218.1711616834899--