Page tree

Versions Compared

Key

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

...

Anchor
owd
owd

OfficeWriter Designer

Anchor
owd_auto
owd_auto

Automatic Installation

. Copy the OfficeWriter Designer install files to the client machine. There are several places to get the OfficeWriterDesinger-Installer-8.#.#.msi

...

:

...

  • Option

...

  • 1:

...

  • The

...

  • OfficeWriter

...

  • Designer

...

  • installer

...

  • is

...

  • included

...

  • in

...

  • the

...

  • installation

...

  • file

...

  • for

...

  • server-side

...

  • component

...

  • of

...

  • OfficeWriter.

...

  • It

...

  • should

...

  • be

...

  • located

...

  • under

...

  • C:\Program

...

  • Files\SoftArtisans\OfficeWriter

...

  • .
  • Option 2:

...

  • The

...

  • latest

...

  • version

...

  • of

...

  • the

...

  • OfficeWriter

...

  • Desinger

...

  • installer

...

  • is

...

  • also

...

  • available

...

  • separately

...

  • for

...

  • download

...

  • on

...

  • the

...

...

...

  • .
  • If evaluating: A link to download the OfficeWriter Designer separately is provided in the evaluation e-mail.

2. Close all Microsoft Office applications.

3. If there are previous versions of the Designer installed, make sure to uninstall the OfficeWriter Designer through Add/Remove programs or Programs and Features.

4. Double-click OfficeWriterDesigner-Installer.msi and follow the instructions.

Note
titleNotes about the OfficeWriter Designer Installer
  • The OfficeWriter Designer is intended for 32-bit version of Office. If you do not have a 32-bit version of Office installed, you will not be able to run the installer.
  • The OfficeWriter Designer Installer can be run on 64-bit or 32-bit systems, but will unpack files under C:\Program Files x86\SoftArtisans\OfficeWriter\Designer
}}
  • on
  • 64-bit
  • systems
  • or
{{
  • C:\Program
  • Files\SoftArtisans\OfficeWriter\Designer
}}
  • for
  • 32-bit
  • systems.
*
  • The
  • OfficeWriter
  • Designer
  • will
  • unpack
  • some
  • sample
  • RDL
  • files
  • under
{{
  • SoftArtisans\OfficeWriter\Designer\samples
}}
  • that
  • use
  • the
  • AdventureWorks
  • 2005
  • database.
  • AdventureWorks
  • must
  • be
  • installed
  • in
  • order
  • for
  • you
  • to
  • run
  • these
samples. {note} {card} {card:label=Manual Installation} h1. Manually Installing OfficeWriter for Reporting Services 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. h1. Manually Installing the OfficeWriter Designer \#Run the automatic installation on one machine in order to unpack the OfficeWriter Designer files. After these files have been unpacked, you can install the OfficeWriter Designer manually on other machines \\# Close all Microsoft Office applications. \\# Open a command prompt window and move to the directory OfficeWriter\Designer. For example, enter *cd C:\Program Files\SoftArtisans\OfficeWriter\Designer*. \\# Enter *regsvr32 SARS8CLT.dll*. A dialog box will inform you that SARS8CLT.dll registered successfully; click *Ok*. \\# Enter *regsvr32 OWAssist.dll*. A dialog box will inform you that OWAssist.dll registered successfully; click *Ok*. \\# Enter *regsvr32 XFClient.dll*. A dialog box will inform you that XFClient.dll registered successfully; click *Ok*. {note}The Application Data folder is hidden by default. In order to show hidden folders, open a Windows Explorer window and go to *Tools*. Select *Folder Options*, then select the *View* tab. Under *Hidden files and folders*, check the radio button beside *Show hidden files and folders*. {note} # Copy *SAWordTemplateAddIn.dotm* from *OfficeWriter\Designer* to *%appdata%\Microsoft\Word\STARTUP*. \\# Copy *SAExcelTemplateAddIn.xlam* from *OfficeWriter\Designer* to *%appdata%\Microsoft\Excel\XLSTART*. \\# Create the Registry Key settings as described below. ** To change an OfficeWriter Designer registry key value: ** Open the Start menu and select *Run*. ** Enter regedit and click *Ok*. ** Open the folder *
  • samples.

...

Anchor
owd_manual
owd_manual

Manual Installation

#Run the automatic installation on one machine in order to unpack the OfficeWriter Designer files. After these files have been unpacked, you can install the OfficeWriter Designer manually on other machines
# Close all Microsoft Office applications.
# Open a command prompt window and move to the directory OfficeWriter\Designer. For example, enter cd C:\Program Files\SoftArtisans\OfficeWriter\Designer.
# Enter regsvr32 SARS8CLT.dll. A dialog box will inform you that SARS8CLT.dll registered successfully; click Ok.
# Enter regsvr32 OWAssist.dll. A dialog box will inform you that OWAssist.dll registered successfully; click Ok.
# Enter regsvr32 XFClient.dll. A dialog box will inform you that XFClient.dll registered successfully; click Ok.

Note

The Application Data folder is hidden by default. In order to show hidden folders, open a Windows Explorer window and go to Tools. Select Folder Options, then select the View tab. Under Hidden files and folders, check the radio button beside Show hidden files and folders.

  1. Copy SAWordTemplateAddIn.dotm from OfficeWriter\Designer to
    %appdata%\Microsoft\Word\STARTUP.
    # Copy SAExcelTemplateAddIn.xlam from OfficeWriter\Designer to
    %appdata%\Microsoft\Excel\XLSTART.
    # Create the Registry Key settings as described below.
    • To change an OfficeWriter Designer registry key value:
    • Open the Start menu and select Run.
    • Enter regedit and click Ok.
    • Open the folder HKEY_CURRENT_USER\Software\SoftArtisans\OfficeWriter\Designer

...

    • .

...

    • Double-click

...

    • the

...

    • key

...

    • you

...

    • want

...

    • to

...

    • update.

...

    • A

...

    • dialog

...

    • will

...

    • open.

...

    • In

...

    • the

...

    • Value

...

    • Data

...

    • field,

...

    • enter

...

    • a

...

    • new

...

    • value

...

    • for

...

    • the

...

    • key.

...

Key

Type

Value Description

Toolbar Caption Style

REG_DWORD

1 - Icon only *2* - Caption only *3* - Icon and caption (default)

Enable MSQuery

REG_DWORD

0 - Disable 'Add Query', 'Edit Query' and 'Delete Query' buttons. (default) *1* - Enable 'Add Query', 'Edit Query' and 'Delete Query' buttons.

Always Ask Param Values

REG_DWORD

0 - Don't ask for parameter values in reports with parameters if valid default values are specified in the RDL file. *1* - Always ask for parameter values in reports with parameters, even if valid default values are specified in the RDL file. (default)

Excel AddIn Default Renderer

REG_SZ

Rendering extension used for viewing report without template in Excel Add-In. "EXCEL" is default.

Word AddIn Default Renderer

REG_SZ

Rendering extension used for viewing report without template in Word Add-In. "HTML4.0" is default.

Debug

REG_SZ

"True" - Enables SOAP request and response dump to c:\temp\PayloadDump.xml

...

and

...

c:\temp\ResponseDump.xml

...

correspondingly.

...

*"False"*

...

-

...

Disables

...

SOAP

...

request

...

and

...

response

...

dump.

...

(default)

...

No

...

Overwrite

...

Prompt

...

REG_DWORD

...

1 - Don't

...

prompt

...

to

...

overwrite

...

RDL

...

file

...

in

...

Save

...

As

...

dialog.

...

*0*

...

-

...

Prompt

...

to

...

overwrite

...

RDL

...

file

...

in

...

Save

...

As

...

dialog.

...

(default)

...

Validate

...

Fields

...

REG_DWORD

...

1 - Validate that each template data field has a field in the data source that binds to it. Generates error on "Save" on the client instead of error on "View" on the server. *0* - Don't validate that each template data field has a field in the data source that binds to it. (default)

Hide Enterprise Features

REG_DWORD

1 - Hides Insert Formula drop-down. *0* - Shows Insert Formula drop-down (default)

No Enterprise Features Warning

REG_DWORD

1 - Disables Enterprise Feature warning. *0* - Enables Enterprise Feature warning. (default)

Help File Path

REG_SZ

Path to chm file. Default value is C:\WINDOWS\Help\OfficeWriterRS.chm

...

SamplesDir

REG_SZ

...

Path

...

to

...

the

...

root

...

or

...

samples

...

(RDL)

...

directory.

...

Default

...

value

...

is

...

C:\Program

...

Files\SoftArtisans\OfficeWriter\Designer\samples

...

InstallDir

REG_SZ

...

Path

...

to

...

install

...

directory.

...

C:\Program

...

Files\SoftArtisans\OfficeWriter\Designer

...

WordUseOpenFileMRU

REG_DWORD

...

0 - Use SampleDir once, then switch to 1 *1* - Use last opened dir (default) *2* - Always use SampleDir

ExcelUseOpenFileMRU

REG_DWORD

0 - Use SampleDir once, then switch to 1 *1* - Use last opened dir (default) *2* - Always use SampleDir

ServerMRU

Subkey

Keeps a list of most recently used (MRU) servers.

To change an OfficeWriter ServerMRU (most recently used servers) registry key value:

  1. Open the Start menu and select Run.
    # Enter regedit and click Ok.
    # Open the folder HKEY_CURRENT_USER\Software\SoftArtisans\OfficeWriter\Designer\ServerMRU

...

  1. .

...


  1. #

...

  1. Double

...

  1. click

...

  1. the

...

  1. key

...

  1. you

...

  1. want

...

  1. to

...

  1. update.

...

  1. An

...

  1. dialog

...

  1. will

...

  1. open.

...


  1. #

...

  1. In

...

  1. the

...

  1. Value

...

  1. Data

...

  1. field,

...

  1. enter

...

  1. a

...

  1. new

...

  1. value

...

  1. for

...

  1. the

...

  1. key.

...

Key

Type

Value

Value Description

Maximum Entries

REG_DWORD

optional, \default - 10

Maximum entries in MRU list. Entries at the bottom of the list are removed to accommodate new server URLs.

MRU#

REG_SZ

Server URL (full)

http://<servername>/ReportServer

...