Manual Installation for SSRS 2012 with SharePoint 2010
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 - 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. 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"