Note | ||
---|---|---|
| ||
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):
- Make sure that the following are installed on the server:
#* Microsoft .NET Framework Redistributable version 3.5 SP1 (or later)
#* MS Reporting Services 2012.
# 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 command Get-SPRSServiceApplication to get the name of the SSRS instance. 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_rs_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"
Code Block |
---|
{note}The name of your SharePoint instance
Note | ||
---|---|---|
# Modify the rssrvpolicy.config file in <MSSQL Directory>\Reporting Services\ReportServer. Add the following security trust codegroup to the file's <CodeGroup> node:
{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 Reporting Server using Report Manager.