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 Current

changes.mady.by.user Gabe Goodwin [softartisans]

Saved on

Key

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

This article will walk you through the steps for building an SSRS Report with the OfficeWriter integration.

Step 1: Create an RDL file using Visual Studio or Report Builder

The report RDL file should have all the data information for running the report. This includes defining the data sources, creating data sets with queries, and adding any report parameters. These details will be used by Reporting Services to retrieve the data when the report is rendered.

Info
titleGood Practice

Try to set everything up in the RDL now before the report has been through the OfficeWriter Designer. Constantly moving between making changes to the data in the report design tool (Visual Studio, Report Builder) and making changes to the Excel or Word template file with the OfficeWriter Designer can corrupt the RDL file.

If you want to render the report with the default rendering extensions, make sure to design your report in the report builder tool as well.

Info
titleGood Practice

Before opening the RDL with the OfficeWriter Designer:

  1. Save a back-up copy of your report. The Designer will add information to the RDL and it is very difficult to revert the RDL to it's original state. Keep a clean back-up copy in case you need to start over.
  2. Upload your report to Report Manager and export to one of the default formats. This will confirm that your queries and data sources are configured correctly for your Reporting Services instance.

Step 2: Put the report in a location so that the users who are designing the report for Excel or Word can reach it

...