OfficeWriter Documentation
.
OfficeWriter v8 Docs
Page tree
ConfigureSpace tools

Versions Compared

Old Version 4

changes.mady.by.user Alison Bird [softartisans]

Saved on

compared with

New Version Current

changes.mady.by.user Gabe Goodwin [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Manual Install

...

titleAbout SSRS 2012

Anchor
ssrs_sp_manual
ssrs_sp_manual

Jump to:

Table of Contents

Introduction

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):.

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)
    • SoftArtisans.OfficeWriter.RS2008.dll (also used for Reporting Services 2012)
    • SoftArtisans.OfficeWriter.WordWriter.dll
    • SoftArtisans.OfficeWriter.ExcelWriter.dll#
  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:

    {newcode}
    Code Block
    $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"

...

  1. 

New-SPRSExtension -ExtensionType "Render" -Identity $app -Name "WordTemplate" -TypeName "SoftArtisans.OfficeWriter.ReportingServices.WordTemplateRenderer,SoftArtisans.OfficeWriter.RS2008"

...

  1. To

...

  1. run

...

  1. the

...

  1. command,

...

  1. type

...

  1. &"C:\FilePath\InstallOfficeWriterForSSRS.ps1"

...

  1. into

...

  1. Management

...

  1. Shell.

...

  1. This

...

  1. step

...

  1. may

...

  1. take

...

  1. a

...

  1. few

...

  1. minutes.

...

  2. Modify the rssrvpolicy.config

...

  1. file

...

  1. in

...

  1. C:\Program

...

  1. Files\Common

...

  1. Files\Microsoft

...

  1. Shared\Web

...

  1. Server

...

  1. Extensions\14\WebServices\

...

  1. 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:

    Code Block
    xml
    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>

...

  1.  Note
    You will likely already have the "FirstMatchCodeGroup" 
...
  1.  CodeGroup 
...
  1.  element 
...
  1.  in 
...
  1.  your 
...
  1.  Render 
...
  1.  node. 
...
  1.  You 
...
  1.  should 
...
  1.  only 
...
  1.  need 
...
  1.  to 
...
  1.  copy 
...
  1.  the 
...
  1.  innermost 
...
  1.  CodeGroup 
...
  1.  element 
...
  1.  (Name="SoftArtisans_OfficeWriter_Strong_Name").
...
  1.  Warning
    The PublicKeyBlob value should be in one line. When you copy the lines above to rssrvpolicy.config, remove the line breaks within the PublicKeyBlob.
  2. To install the samples, upload the RDL files in OfficeWriter\ReportingServices\Samples
...
  1.  to 
...
  1.  the 
...
  1.  SharePoint 
...
  1.  report 
...
  1. 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-.
     Code Block
    $app = Get-SPRSServiceApplication -Name "enter_your_ssrs_instance_name_here"


...
  1. Remove-SPRSExtension -ExtensionType "Render" -Identity $app -Name "XLTemplate" -TypeName "SoftArtisans.OfficeWriter.ReportingServices.ExcelTemplateRenderer,SoftArtisans.OfficeWriter.RS2008"


...
  1. Remove-SPRSExtension -ExtensionType "Render" -Identity $app -Name "WordTemplate" -TypeName "SoftArtisans.OfficeWriter.ReportingServices.WordTemplateRenderer,SoftArtisans.OfficeWriter.RS2008"

# To run the command, type &"C:\FilePath\InstallOfficeWriterForSSRS.ps1" into Management Shell. This step may take a few minutes. 
# Use the License Key Manager (LicenseManager.exe) to remove the license key from your server.