ASP.NET Samples
    .NET Application Samples
    Reporting Services Samples

    View The Latest
OfficeWriter Docs

    OfficeWriter Home
    OfficeWriter Resources
    OfficeWriter Demos

OfficeWriter v4.6.0 Reporting Services 2005 and 2000 Sample Reports

About OfficeWriter Reporting Services 2005 and 2000 Sample Reports

OfficeWriter v4.6.0 offers full support for both SQL Server Reporting Services 2005 and 2000 editions.

The items listed on this page are sample Reporting Services reports that were created by the OfficeWriter Designer.

Each of these sample reports are published to Reporting Services on SoftArtisans' servers and will be rendered and streamed to your browser when you click the "Render" button.

The form pages for these sample reports requests the rendered report from Reporting Services using a URL link to /ReportServer. View the source of the form pages to see the URL used to request the reports.

You can download these reports as RDL files to run on your Reporting Services instance. To run these reports on your server, please note the following requrements:
  • Rendering extensions: SoftArtisans OfficeWriter Reporting Services rendering extensions must be installed on your Reporting Services machine.

  • Sample Databases: Below you will find links to download RDL files for Reporting Services 2000 or 2005. The 2005 reports require the AdventureWorks sample database that ships with Reporting Services 2005. The 2000 reports require the AdventureWorks2000 sample database which shipped with Reporting Services 2000. Certain reports may have unique database requirements which will be noted in the download link.

    You can download popular SQL Server sample databases from Microsoft here:

Each report provides a list of export format choices depending on whether or not it is a Word or Excel report. The various export formats are described here:

  • OfficeWriter for Excel - For Excel reports was designed in Excel with the OfficeWriter designer. Render it with the OfficeWriter rendering extension to get 100% native, full-featured Excel output. Preserves all features present in the designer template workbook.
  • OfficeWriter for Word - For Word documents designed in Word with OfficeWriter Designer. Preserves all word features present in the designer template document.
  • Standard Excel - The standard out-of-the-box Reporting Services Excel rendering extension, generated from RDL. Note: Standard Word is not available. For Word output, use OfficeWriter for Word.
  • Standard HTML - Standard out-of-the-box HTML rendering by Reporting Services.

How to use these reports with OfficeWriter

Click the "Download RDL file for this report" link on each report to download the RDL file that defines the report. You can open the RDL file in OfficeWriter designer to view the Excel or Word template that is used by OfficeWriter. Follow these steps:

  1. Download and save the RDL file(s) that you wish to view
  2. Open Word or Excel. If you have OfficeWriter Designer installed on your computer you will see the toolbar appear.
  3. In the OfficeWriter Designer, click "Open RDL" to open the report and view the template file.
  4. You can now make any changes you want to the template file. Use the dropdown menus in OfficeWriter Designer to place more data fields if you wish.
  5. Publish the report to your Reporting Services instance by clicking "Publish" or "View".
    Note: You must have the required databases installed to successfully render the reports.

Sample Reports

Excel Territory Sales Drilldown Report

Overview

This report demonstrates a drilldown sales report rendered by OfficeWriter for Excel. The initial report displays a list of orders grouped and subtotaled by territory. When you click on one of the order numbers, a subreport will be rendered which will display the drilldown view containing order detail rows.

Run the report

Select an export format from the dropdown and click "Render Report":

Download the RDL file for this report (RS 2005)
Subreport - Download the RDL file for this report (RS 2005)

Download the RDL file for this report (RS 2000)
Subreport - Download the RDL file for this report (RS 2000)


Excel Product Sales Report

Overview

This is an OfficeWriter Enterprise Edition sample report. This report includes the following Enterprise Edition features:

  • Formulas - Formulas are custom-built with the OfficeWriter Designer
  • Report Parameters - Define render-time parameters to use for the report DataSets.

Run the report

The following selections will be passed to Reporting Services as report parameters. If there are no values displayed in the rendered report, you may have chosen an invalid date range. Change your selections for Start Date and End Date and try again.
Product SubCategory
Start Date
End Date

Select an export format and click "Render Report":


Download the RDL file for this report (RS 2005)
Download the RDL file for this report (RS 2000)


Word Company Directory Report

Overview

OfficeWriter can render reports in Word and Excel. This report demonstrates Word rendering by generating a document listing the employees in the Information Services department of the AdventureWorks company.

Run the report

Select an export format and click "Render Report":


Download the RDL file for this report (RS 2005)
Download the RDL file for this report (RS 2000)


Word Purchase Order Report

Overview

This is a standard purchase order document generated by OfficeWriter for Word and Reporting Services. There are two DataSets used in this report: one for the order header information and totals, and another for the order detail data. The Word table in the template dynamically grows depending on how many rows of order detail data are returned by the query.

Run the report

Select a Sales Order ID:

Select an export format and click "Render Report":


Download the RDL file for this report (RS 2005)
Download the RDL file for this report (RS 2000)


Excel Nested Data Report

Overview

This report demonstrates how conditional formatting can be used to create a nested report.

Note: This report requires the Northwind database.

Run the report

Select an export format from the dropdown and click "Render Report":

Download the RDL file for this report (Northwind, RS2000/RS2005)


Excel Analysis Services/OLAP Sample Report

Overview

This report demonstrates how to leverage OLAP technology with OfficeWriter, Excel, and Reporting Services. The RDL file contains a MDX query that runs against Analysis Services and the FoodMart database. The workbook generated by OfficeWriter contains a pivot table and pivot chart.

The query for this report was designed in Visual Studio .NET 2003 and then OfficeWriter Designer was used to add rich Excel capabilities to the report. This report displays FoodMart promotional data based on the gender and media type selected below.

Run the report

Select report parameters below:
Gender
Media type

Choose an export format and click "Render Report".
Note: Excel workbooks with pivot tables must be saved to disk before being opened in Excel. In the Save As dialog, click "Save" and then "Open".


Download the RDL file for this report (RS 2000)





Copyright 2011 © SoftArtisans, Inc. All Rights Reserved.