Message-ID: <1090398865.2325.1710831130518.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_2324_216129306.1710831130518" ------=_Part_2324_216129306.1710831130518 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Setting global ExcelTemplate and WordTemplate properties in Repo= rting Services

Setting global ExcelTemplate and WordTemplate properties in Reporti= ng Services

Intro

=20

The server-side OfficeWriter renderers for Reporting Services use ExcelT= emplate and WordTemplate to populate the report and stream it back to the u= ser. However, since Reporting Services does not provide runtime control, it= is not possible to access the ExcelTemplate and WordTemplate APIs directly= in order to set various properties.

=20

In version 3.9.2 new functionality was added to turn on certain OfficeWr= iter properties by adding keys to the Reporting Services web.config. Additi= onal properties were made available in version 8.5.0. See below for more de= tails.

=20

Setting the Properties

=20

In version 3.9.2, the following properties were made available:

=20 =20

In version 8.5.0 the following properties were added:

=20
=20

In version 8.6.1 the following property was added:

=20 =20

To set these properties on the Server go to web.config located in \Repor= ting Services\ReportServer. Add the following code for the desired properti= es:

=20
=20
<appSettings>
             <add key=3D"PreserveStrings" value=3D"True&q=
uot;/>
             <add key=3D"RemoveExtraDataMarkers" value=3D"=
;True"/>

             <add key=3D"EnableNextFields" value=3D"True&=
quot;/>
             <add key=3D"UpdateIfFields" value=3D"True&qu=
ot;/>
             <add key=3D"PreserveFields" value=3D"True&qu=
ot;/>
             <add key=3D"UnlinkIfFields" value=3D"True&qu=
ot;/>
             <add key=3D"LineBreaksToParagraphs" value=3D"=
;True" />
</appSettings>
=20
=20

Put the code before the closing of the configuration tag, as in the imag= e below. Make sure not to place it inside any other tag. If web.config alre= ady contains an appSettings section, add the keys to the existing s= ection. Do not create another appSettings section= .

=20

=20

Note: The keys are case sensitive so make sure True is = capitalized. The default value of these properties is False.

------=_Part_2324_216129306.1710831130518--