Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
ssrs
ssrs

Anchor
ssrs_auto
ssrs_auto

Automatic Installation

Intro

The OfficeWriter 8 installer is available in 64-bit (OfficeWriter-Installer-8.#.#-x64.msi

...

)

...

and

...

32-bit

...

(

...

OfficeWriter-Installer-8.#.#-x86.msi

...

).

...

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.

Running the Installer

  1. Check that your system meets the System Requirements. You MUST have SQL Server Reporting Services installed on the machine that you are trying to install OfficeWriter for SSRS. If SSRS is not detected, it will not be available as a custom setup option.
    # The OfficeWriter for SSRS integration requires modifying several SSRS config files and adding DLLs to the bin directory. To ensure a stable installation, STOP the SQL Server Reporting process before installing OfficeWriter.
    # 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 to proceed to the End-User License Agreement.
    # Read the End-User License Agreement and click Next when finished.
    !EULA_ow.png!
    # Click Next to proceed to the license key entry.
    # You will be prompted for a license key. Enter a license key into the box and click Check 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 - 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
    Wiki Markup
    
    \!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. Click *Next* to proceed to the custom setup options.
    \\!licensekey_check_ow.png!
    

...

  • \\# 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. 

...

  • Click *Next* when done.
    \\!components_ow.png!
    

...

  • \\# 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.* Click *Next* when done.
    \\SSRS-specific assemblies will be unpacked to a subfolder called *Reporting Services*. 
    

...

  • \\!location_ow.png!
    

...

  • \\# 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 original OfficeWriter Designer installer to the destination folder. This is recommended. Click *Install* when done.
    \\!ssrs_2_ow.png!
    

...

  • \\# The OfficeWriter installer requires administrative privileges to write the license key to the registry. On Windows Vista and above, depending on your UAC settings, you may be prompted for UAC elevation during the installation process.
    

...

  • \\!ready_ow.png!
    \\# Click *

...

  • Finished* to 

...

  • exit the 

...

  • installer.
    

...

  • \\!done_ow.png!
    \\# *START* the SQL Server Reporting Services process. 
    
    {anchor:ssrs_manual}
    h1. Manual Installation
    
    h2. Installation files
    
    The following files are unpacked to the destination folder selected during the automatic installation process and are needed for the manual installation process. 
    
    {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 {color:#808080}(EE only){color} |
    | {center}{*}Reporting Services Integration{*}{center} | SoftArtisans.OfficeWriter.SSRS2008.dll or SoftArtisans.OfficeWriter.SSRS2005.dll | * SSRS integration assembly for SSRS 2012/2008 (R2) or SSRS 2005 |
    | {center}{*}

...

  • License Manager{*}{center} | LicenseManager.exe | Manage, add, and remove license keys for OfficeWriter. |
    

...

  • {

...

  • align}
    
    

...

  • 
    

...

  • {

...

  • note:title=About SSRS 2012}
    There are no separate files or instructions for installing OfficeWriter with SSRS 2012. 

...

  • The 

...

  • files for SSRS 

...

  • 2008 

...

  • can 

...

  • be 

...

  • used 

...

  • to 

...

  • install 

...

  • for 

...

  • SSRS 

...

  • as 

...

  • well. 

...

  • If installing 

...

  • for 

...

  • SSRS 2012, 

...

  • just 

...

  • use the files and instructions for installing with SSRS 2008.
    
Note

Microsoft recommends that you stop SSRS before installing any new components. When installing OfficeWriter, please stop SSRS, finish installing OfficeWriter, and then start SSRS again to ensure a stable installation.

  1. Make sure that the following are installed on the server:
    #* Microsoft .NET Framework Redistributable version 2.0 (or later)
    #* MS Reporting Services 2012, 2008 R2, 2008, or 2005.
    # 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

...

    • or

...

    • Reporting

...

    • Services

...

    • 2012)

...

    • 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>

...

    • Code Block
      For Reporting Services 2008 or 2012:
      {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 Block

...

    • 
      \{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>
      
      {

...

    • 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.

...

  1. To install the samples,

...

  1. upload

...

  1. the

...

  1. RDL

...

  1. files

...

  1. in

...

  1. OfficeWriter\ReportingServices\Samples

...

  1. to

...

  1. the

...

  1. Reporting

...

  1. Server

...

  1. using

...

  1. Report

...

  1. Manager.