Page History

...

1. Make sure that the following are installed on the server:
   #* Microsoft .NET Framework Redistributable version 3.5 SP1 (or later)
   #*
   • MS Reporting Services 2012
   .
   • SharePoint 2010 or later
     # 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 If you don't know the name of your Reporting Services instance, run the command Get-SPRSServiceApplication to get the name of the SSRS instance within Management Shell. 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_rsssrs_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"

{note}The name of your SharePoint instance

                5E86EF9DD3233F9F130F8891911345176650F72330F84CA3F54C96DEB08439680660F02872EEF5DA3955
                A14C63F96E57DFB71B1535280C37DA2CB5BA37D78A9882414DB11F67FD66DEBC4AD93DD34F4A587D34D
                B4D23D9C6AF83431D88A7EF42BB01082913F3560DCB50129C5BBA7ECA0DE8BC286DA74F58FADE"/>
            </CodeGroup>
          </CodeGroup>
        </PolicyLevel>
      </policy>
    </security>
  </mscorlib>
</configuration>
{code}
\{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").

\\# To run the command, type {{&"C:\FilePath\InstallOfficeWriterForSSRS.ps1"}} into Management Shell. This step may take a few minutes. 
\\# Modify the *rssrvpolicy.config* file in * C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\Reporting*. 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

...

{note}
{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. {warning}
# To install the samples, upload the RDL files in *OfficeWriter\ReportingServices\Samples* to the

...

 SharePoint report library. 


h1. Manual Uninstall

# Start SharePoint 2010 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". 
\\# To remove the rendering extensions, you will need to run a PowerShell command. First, create a text file called "UnInstallOfficeWriterForSSRS.ps1" that contains the following: 
\{newcode}

$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"

# To run the command, type &"C:\FilePath\InstallOfficeWriterForSSRS.ps1" into Management Shell. This step may take a few minutes.