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
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.
=20In 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.
=20In version 3.9.2, the following properties were made available:
=20In version 8.5.0 the following properties were added:
=20In version 8.6.1 the following property was added:
=20To 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<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
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 =20Note: The keys are case sensitive so make sure True is = capitalized. The default value of these properties is False.