Manual Installation for SSRS 2012 with SharePoint 2010/2013
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
- 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
# 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:
{newcode}
$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"
$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"