Jump to:


There were some significant infrastructure changes made for SSRS 2012 in SharePoint integration mode that require a different installation process from native mode. The instructions for installing onto SSRS 2012 or SSRS 2016 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).

Manually Installing OfficeWriter

  1. Make sure that the following are installed on the server:

  2. Copy the following files to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\Reporting\bin (for SharePoint 2010) OR to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\WebServices\Reporting\bin (for SharePoint 2013)
  3. Run LicenseManager.exe to install the OfficeWriterEE or OfficeWriterSE key.
  4. Start SharePoint 2010/2013 Management Shell. If you don't know the name of your Reporting Services instance, run the command Get-SPRSServiceApplication within Management Shell. For example, "SSRS2012App".
  5. 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:

    $app = Get-SPRSServiceApplication -Name "enter_your_ssrs_instance_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"
  6. To run the command, type &"C:\FilePath\InstallOfficeWriterForSSRS.ps1" into Management Shell. This step may take a few minutes.
  7. Modify the rssrvpolicy.config file in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\Reporting (for SharePoint 2010) OR C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\WebServices\Reporting (for SharePoint 2013). Add the following security trust codegroup to the file's <CodeGroup> node:

            <PolicyLevel version="1">
              <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="Nothing">
                <CodeGroup class="UnionCodeGroup"
                  Description="This code group grants SoftArtisans OfficeWriter code full trust.">

    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.

  8. To install the samples, upload the RDL files in OfficeWriter\ReportingServices\Samples to the SharePoint report library.

Manually Remove the OfficeWriter Rendering Extensions

  1. Follow the installation instructions in reverse.
  1. To uninstall the rendering extensions, replace New- in the PowerShell script with Remove-.

    $app = Get-SPRSServiceApplication -Name "enter_your_ssrs_instance_name_here"
    Remove-SPRSExtension -ExtensionType "Render" -Identity $app -Name "XLTemplate" -TypeName "SoftArtisans.OfficeWriter.ReportingServices.ExcelTemplateRenderer,SoftArtisans.OfficeWriter.RS2008"
    Remove-SPRSExtension -ExtensionType "Render" -Identity $app -Name "WordTemplate" -TypeName "SoftArtisans.OfficeWriter.ReportingServices.WordTemplateRenderer,SoftArtisans.OfficeWriter.RS2008"