There were some significant infrastructure changes made for SSRS 2012 in SharePoint integration mode that require a different installation process from native mode. These instructions are outlined below. |
To install OfficeWriter the first time, run the automatic installation. Once the OfficeWriter installer has unpacked the dll files that contain OfficeWriter, you can re-install OfficeWriter manually (for example, if you are moving OfficeWriter to a different server):
- Make sure that the following are installed on the server:
#* Microsoft .NET Framework Redistributable version 3.5 SP1 (or later)
#* MS Reporting Services 2012.
# Copy the following files to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\Reporting\bin
- SoftArtisans.OfficeWriter.RS2008.dll (also used for Reporting Services 2012)
- SoftArtisans.OfficeWriter.WordWriter.dll
- SoftArtisans.OfficeWriter.ExcelWriter.dll
# Run LicenseManager.exe to install the OfficeWriterEE or OfficeWriterSE key.
# Start SharePoint 2010 Management Shell. Run the command Get-SPRSServiceApplication to get the name of the SSRS instance. For example, "SSRS2012App".
# To install the rendering extensions, you will need to run a PowerShell command. First, create a text file called "InstallOfficeWriterForSSRS.ps1" that contains the following:
{newcode}
$app = Get-SPRSServiceApplication -Name "enter_your_rs_name_here"
New-SPRSExtension -ExtensionType "Render" -Identity $app -Name "XLTemplate" -TypeName "SoftArtisans.OfficeWriter.ReportingServices.ExcelTemplateRenderer,SoftArtisans.OfficeWriter.RS2008"
New-SPRSExtension -ExtensionType "Render" -Identity $app -Name "WordTemplate" -TypeName "SoftArtisans.OfficeWriter.ReportingServices.WordTemplateRenderer,SoftArtisans.OfficeWriter.RS2008"
{note}The name of your SharePoint instance
# Modify the rssrvpolicy.config file in <MSSQL Directory>\Reporting Services\ReportServer. Add the following security trust codegroup to the file's <CodeGroup> node:
{code:xml}
<configuration>
<mscorlib>
<security>
<policy>
<PolicyLevel version="1">
<CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="Nothing">
<CodeGroup class="UnionCodeGroup"
version="*"
PermissionSetName="FullTrust"
Name="SoftArtisans_OfficeWriter_Strong_Name"
Description="This code group grants SoftArtisans OfficeWriter code full trust.">
<IMembershipCondition
class="StrongNameMembershipCondition"
version="*"
PublicKeyBlob="00240000048000009400000006020000002400005253413100040000010001004779CB207F11
5E86EF9DD3233F9F130F8891911345176650F72330F84CA3F54C96DEB08439680660F02872EEF5DA3955
A14C63F96E57DFB71B1535280C37DA2CB5BA37D78A9882414DB11F67FD66DEBC4AD93DD34F4A587D34D
B4D23D9C6AF83431D88A7EF42BB01082913F3560DCB50129C5BBA7ECA0DE8BC286DA74F58FADE"/>
</CodeGroup>
</CodeGroup>
</PolicyLevel>
</policy>
</security>
</mscorlib>
</configuration>
{note}You will likely already have the "FirstMatchCodeGroup" CodeGroup element in your Render node. You should only need to copy the innermost CodeGroup element (Name="SoftArtisans_OfficeWriter_Strong_Name"). |
The PublicKeyBlob value should be in one line. When you copy the lines above to rssrvpolicy.config, remove the line breaks within the PublicKeyBlob. |
- To install the samples, upload the RDL files in OfficeWriter\ReportingServices\Samples to the Reporting Server using Report Manager.