OfficeWriter Documentation
.
SSRS Integration v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 2

changes.mady.by.user Alison Bird [softartisans]

Saved on

compared with

New Version 3

changes.mady.by.user Alison Bird [softartisans]

Saved on

Key

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

...

This tutorial will help you design your first report in Excel using the OfficeWriter for Excel Designer from an existing report file (RDL) that was created in Visual Studio or Report Builder. To follow this demonstration you need the AdventureWorks sample database which is an optional component in the Reporting Services installation. We will build a simple employee list and display some basic information about each employee.

Before you start, verify the following
Note
Info
titleTutorial Requirements:
  1. Reporting Services is installed on a server you can access, working properly, and you have rights to publish and view reports.
  2. The AdventureWorks database data base (which ships with is an optional component in the Reporting Services installation) is installed on the Reporting Services server.
  3. OfficeWriter Renderer is installed on the Reporting Services server.
The
  1. Report Server
  2. OfficeWriter Designer
Client
  1. is installed on your local PC
.

For more information on installing and configuring OfficeWriter Reporting Services Integration, see Installation or contact your System Administrator.

OfficeWriter Designer Toolbar

The control center for creating reports with OfficeWriter is the OfficeWriter Designer toolbar. When you open Excel, you will see the toolbar directly underneath the Excel toolbar, above your worksheet.Image Removedthe OfficeWriter Designer tab in the ribbon.

Image Added

If you do not see the toolbar:

  1. Open Excel's View menu and select >Toolbars > OfficeWriter.
    # Check OfficeWriter. If OfficeWriter is not listed, run the OfficeWriter client installer.

If your toolbar does not contain query-building buttons (Add Query, Edit Query, etc.), your registry settings have been set to disable MS Query. These buttons are not required for this tutorial, so you do not need to make any changes to your installation.

  1. Go to the Office menu button (2007) or File tab (2010) in the upper left hand corner.
  2. Click Excel options
  3. Select Add-Ins from the left menu
  4. At the bottom, select Disabled Items from the Manage drop-down menu.
  5. Click Go
  6. If OfficeWriter Designer is there, select and click Enable

Opening a Report File

An a RDL file is an xml-based report definition file. We will open an RDL file created in Visual Studio. The file contains a database connection and a query. The query fields will appear in a drop-down list on the OfficeWriter toolbar. You will be able to insert these fields as merge fields (data placeholders) in the report template. You will not be able to create additional queries.

...