...
- 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 (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
- SoftArtisans.OfficeWriter.PowerPointWriter.dll
- Run LicenseManager.exe to install the OfficeWriterEE or OfficeWriterSE key.
- 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".
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:
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" New-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. 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:
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>
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").
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.
- To install the samples, upload the RDL files in OfficeWriter\ReportingServices\Samples to the SharePoint report library.
...