Page tree

Versions Compared

Key

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

 

Jump to:

...

The OfficeWriter 8 installer is available in 64-bit (OfficeWriter-Installer-89.#.#-x64.msi) and 32-bit (OfficeWriter-Installer-89.#.#-x86.msi). The bitness refers to the bitness of the operating system, not the version of SQL Server Reporting Services.

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

...

ProductFileDescription
ExcelWriter

SoftArtisans.OfficeWriter.ExcelWriter.dll

  • .NET ExcelTemplate object 
  •  .NET ExcelApplication object (EE only)
PowerPointWriterSoftArtisans.OfficeWriter.PowerPointWriter.dll
  • .NET PowerPointTemplate object (EE only)
  •  .NET PowerPointApplication object (EE only)
WordWriter

SoftAartisans.OfficeWriter.WordWriter.dll

  • .NET WordTemplate object

  • .NET WordApplication object (EE only)

Reporting Services Integration

SoftArtisans.OfficeWriter.SSRS2008.dll or

SoftArtisans.OfficeWriter.SSRS2005.dll

  •  SSRS integration assembly for SSRS 2012/2008 (R2) or SSRS 2005
 License Manager LicenseManager.exe Manage, add, and remove license keys for OfficeWriter.

...

  1. Run the OfficeWriter installer on another machine with SQL Server Reporting Services to unpack the necessary installation files (see above).

  2. Make sure that your system meets the System Requirements.

  3. Installing OfficeWriter for SSRS requires modifying several SSRS config files and dropping DLLs in the bin directory. STOP SQL Server Reporting Services process before installing OfficeWriter.

  4. Copy the following files to <MSSQL Directory>\Reporting Services\ReportServer\bin

    1. SoftArtisans.OfficeWriter.RS2005.dll (for Reporting Services 2005) or SoftArtisans.OfficeWriter.RS2008.dll (for Reporting Services 2008 or Reporting Services 2012)

    2. SoftArtisans.OfficeWriter.WordWriter.dll

    3. SoftArtisans.OfficeWriter.ExcelWriter.dll

       

  5. Run LicenseManager.exe to install the OfficeWriterEE or OfficeWriterSE key

  6. Modify the RSReportServer.config file in <MSSQL Directory>\Reporting Services\ReportServe*. Copy the following report rendering extension declaration to the file's <Render> node:
    For Reporting Services 2005:

    Code Block
    languagexml
    <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>

    For Reporting Services 2008 or 2012:

    Code Block
    languagexml
    <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>
    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.

  7. Modify the rssrvpolicy.config file in <MSSQL Directory>\Reporting Services\ReportServer. Add the following security trust codegroup to the file's <CodeGroup> node:

    Code Block
    languagexml
    <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").

    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.

  8. To install the samples, upload the RDL files in OfficeWriter\ReportingServices\Samples to the Reporting Server using Report Manager.

...