View Source

{anchor:ssrs}
h1. Server-Side OfficeWriter

{anchor:ssrs_auto}
h2. Automatic Installation

The OfficeWriter 8 installer is available in 64-bit (*OfficeWriter-Installer-8.#.#-x64.msi*) and 32-bit (*OfficeWriter-Installer-8.#.#-x86.msi*). 

{note}
There is a single OfficeWriter installer that that handles installing any configuration of OfficeWriter, regardless of which edition (SE or EE) or components (ExcelWriter, WordWriter, SSRS integration) you have purchased. 
{note}

h3. 1. Welcome Screen

Double click the msi to begin installing OfficeWriter for .NET: 

!welcome_ow.png!

*Note:* If you have a previous version of OfficeWriter installed, you may be prompted to upgrade or remove the existing version of OfficeWriter. We recommend that you follow the steps to remove the previous version of OfficeWriter before continuing with your installation.

Click *Next*. 


h3. 2. End-User License Agreement

Read the End-User License Agreement and click *Next* when finished.

!EULA_ow.png!

Click *Next*.

h3. 3. OfficeWriter License Key

You will be prompted for a license key. 

{note:title=Where to find your license key}
If you are evaluating, your 30-day OfficeWriter EE license key was sent in your evaluation e-mail.

If you have purchased the product, you can find your license keys:
* In the original order confirmation e-mail
* On the [OfficeWriter site|http://www.officewriter.com/product-updates] - You will need to log in with the credentials that were used to purchase the product. These credentials are also available in the original order confirmation e-mail.  
{note}

Enter a license key into the box and click *Check Key*. 

!licensekey_ow.png!

The installer will confirm what edition (Standard or Enterprise) the license key is. Once the license key is verified, the *Next* button will be enabled. 

!licensekey_check_ow.png!

h3. 4. Custom Setup

You will need to select the components to install. To include or exclude any components from your installation, click on the drop-down next to the component. 

{note} In order to install OfficeWriter for SQL Server Reporting Services, you *must* run the installer on a machine that has SSRS installed. If the installer cannot find any SSRS installation, it will not provide you with the option to install OfficeWriter for SQL Server Reporting Services. {note}

!components_ow.png!

h3. 5. Destination Folder

The destination folder is where the OfficeWriter assemblies and utilities will be unpacked. By default, the destination folder will be *C:\Program Files\SoftArtisans\OfficeWriter.*

SSRS-specific assemblies will be unpacked to a subfolder called *Reporting Services*. 

!location_ow.png!

h3. 6. Reporting Services Integration

The installer will attempt to locate any instances of SQL Server Reporting Services on the machine. Select the installation to add OfficeWriter to. 
You will also be given the option to unpack the OfficeWriter Designer installer to the destination folder. This is recommended. 

!ssrs_2_ow.png!


h3. 7. Ready to install

The OfficeWriter installer requires administrative privileges to write the license key to the registry. You will be prompted for administrative credentials before the installation begins.

!ready_ow.png!

Click *Install* to start the installation. This will:
* Install OfficeWriter for Reporting Services, which will make changes to some Report Server config files. 
* Register the license key provided earlier
* Unpack the files listed below

{align:center}
*Installation Files*
\|| {center}Prodcut{center} || {center}File{center} || {center}Description{center} ||
| {center}{*}ExcelWriter{*}{center} | SoftArtisans.OfficeWriter.ExcelWriter.dll | * .NET ExcelTemplate object
* .NET ExcelApplication object {color:#808080}(EE only){color} |
| {center}{*}WordWriter{*}{center} | SoftAartisans.OfficeWriter.WordWriter.dll | * .NET WordTemplate object
* .NET WordApplication object&nbsp;{color:#808080}(EE only){color} |
| {center}{*}Reporting Services Integration{*}{center} | SoftArtisans.OfficeWriter.SSRS2008.dll or SoftArtisans.OfficeWRiter.SSRS2005.dll | * SSRS integration assembly for SSRS 2008 (R2) or SSRS 2005 |
| {center}{*}OfficeWriter Designer Installer{*}{center} | OfficeWriterDesigner-Installer-8.#.#.msi | Installer for the client-side OfficeWriter Designer |
| {center}{*}License Manager{*}{center} | LicenseManager.exe | Manage, add, and remove license keys for OfficeWriter. |
| {center}{*}SharePoint Integration{*}{center} | SoftArtisans.OfficeWriter.ExcelWriter.SharePointIntegration.dll \\ SoftArtisans.OfficeWriter.WordWriter.SharePointIntegration.dll | SharePoint Specific Functions&nbsp;{color:#808080}(EE only){color}|
{align}

If you chose not to install any of the above components, they will not be unpacked to the destination folder.

h3. 7. Setup Complete

!done_ow.png!

{info}Now that the server-side OfficeWriter for SSRS is installed, we recommend that you install the OfficeWriter Designer to the desired client machines.{info}

----

{anchor:ssrs_manual}
h2. Manual Installation

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 2.0|http://www.microsoft.com/download/en/details.aspx?id=19] (or later)
\\#* MS Reporting Services 2005 or 2008
\\# Copy the following files to *<MSSQL Directory>\Reporting Services\ReportServer\bin*
#* *SoftArtisans.OfficeWriter.RS2005.dll* (for Reporting Services 2005) or *SoftArtisans.OfficeWriter.RS2008.dll* (for Reporting Services 2008)
#* *SoftArtisans.OfficeWriter.WordWriter.dll*
#* *SoftArtisans.OfficeWriter.ExcelWriter.dll* .
\\# Run *LicenseManager.exe* to install the OfficeWriterEE or OfficeWriterSE key.
\\# Modify the *RSReportServer.config* file in *<MSSQL Directory>\Reporting Services\ReportServer*. Copy the following report rendering extension declaration to the file's *<Render>* node:
For Reporting Services 2005:
\{newcode:language=xml}
<Configuration>
  <Extensions>
    <Render>
      <Extension Name="XLTemplate" Type="SoftArtisans.OfficeWriter.ReportingServices.ExcelTemplateRenderer,
          SoftArtisans.OfficeWriter.RS2005"/>
      <Extension Name="WordTemplate" Type="SoftArtisans.OfficeWriter.ReportingServices.WordTemplateRenderer,
          SoftArtisans.OfficeWriter.RS2005"/>
    </Render>
  </Extensions>
</Configuration>
{newcode}
\\For Reporting Services 2008:
\{code:xml}
<Configuration>
  <Extensions>
    <Render>
      <Extension Name="XLTemplate" Type="SoftArtisans.OfficeWriter.ReportingServices.ExcelTemplateRenderer,
          SoftArtisans.OfficeWriter.RS2008"/>
      <Extension Name="WordTemplate" Type="SoftArtisans.OfficeWriter.ReportingServices.WordTemplateRenderer,
          SoftArtisans.OfficeWriter.RS2008"/>
    </Render>
  </Extensions>
</Configuration>
{code}
\\{note}You will likely already have Extension elements in your Render node. You should only need to copy the Extension element lines below your existing Extension elements in the Render node.{note}
\\# Modify the *rssrvpolicy.config* file in *<MSSQL Directory>\Reporting Services\ReportServer*. 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
                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").{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 Reporting Server using Report Manager.

{include:Installing OfficeWriter Designer}