What is SSRS Integration?
OfficeWriter Reporting Services Integration enhances Microsoft SQL Server Reporting Services by allowing users to design and deliver their reports in native Word and Excel. Reporting Service Integration consists of two components:
The OfficeWriter Renderer
The OfficeWriter renderer runs on the Reporting Services server.
The renderer takes a template RDL file that was designed using the OfficeWriter Designer, and populates it with data supplied by Reporting Services.
The OfficeWriter Designer
The OfficeWriter Designer is a toolbar add-in for Microsoft Excel and Word.
With the OfficeWriter Designer, you design a report in Word or Excel. Any formula, charts, or other advanced Office functionality will be present in the output file when the report is run.
Getting started with SSRS Integration
More Information
SSRS Integration for Excel
How to Create Excel Reports
What is an OfficeWriter Excel Template?
Adding a Template to an Existing Report
Adding Data Markers
Grouping And Nesting
Adding Formulas to an Excel Report
Excel Reports with Parameters
Working With Charts
Working With PivotTables
Working With PivotCharts
Using MS Query in Excel to Design Reports
- Creating a New Template
- Removing Queries from an Excel Report
- Defining Parameters with MS Query in Excel
Saving and Deploying Your Excel Report
Viewing Your Excel Report
The OfficeWriter Designer for Excel
The OfficeWriter Designer for Excel 2003
OfficeWriter Excel Dialogs
- OfficeWriter Designer for Excel - Open Report
- OfficeWriter Designer for Excel - Step 1 of 3
- OfficeWriter Designer for Excel - Step 2 of 3
- OfficeWriter Designer for Excel - Data Source Credentials
- OfficeWriter Designer for Excel - Publish Report
- OfficeWriter Designer for Excel - Report Parameters
- OfficeWriter Designer for Excel - Valid Values
- OfficeWriter Designer for Excel - Enterprise Feature
- OfficeWriter Designer for Excel - Insert Formula
- OfficeWriter Designer for Excel - Formula Manager
- OfficeWriter Designer for Excel - Report Browser
- OfficeWriter Designer for Excel - Save Report