Message-ID: <836148858.10493.1711726419529.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10492_1169174244.1711726419529" ------=_Part_10492_1169174244.1711726419529 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Reporting Services 2005 and 2000 Excel Sample Reports

Reporting Services 2005 and 2000 Excel Sample Reports

About OfficeWriter Reporting Services 2005 and 2000 Sample Report= s

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:

How to use these reports with OfficeWriter

Click the "Download RDL file for this report" link on each rep= ort 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 us= ed 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 re= port and view the template file.
  4. You can now make any changes you want to the template file. Use the dro= pdown menus in OfficeWriter Designer to place more data fields if you wish.=
  5. Publish the report to your Reporting Services instance by clicking &quo= t;Publish" or "View".
    Note: You m= ust have the required databases installed to successfully render the report= s.

 

Sam= ple Reports

Excel Territory Sales Drilldown Report

Overview=

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

Downloads

Download the RDL file for this report (RS 20= 05)
S= ubreport- 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 (R= S 2000)
 

 


Excel Product Sales Report

Overview

This is an OfficeWriter Enterprise Edition sample report. This report in= cludes the following Enterprise Edition features:

 

Downloads

Download the RDL file for this report (RS 2005)

Download the RDL file for this report (RS 2000)

 


Excel Nested Data Report

Overvi= ew

This report demonstrates how conditional formatting can be used to creat= e a nested report.

Note: This report requires the Northwind database.=

Downloads

Download the RDL file for this report (Northwind, RS200= 0/RS 2005)

 


Excel Analysis Ser= vices/OLAP Sample Report

Overview

This report demonstrates how to leverage OLAP technology with OfficeWrit= er, Excel, and Reporting Services. The RDL file contains a MDX query that r= uns against Analysis Services and the FoodMart database. The workbook gener= ated by OfficeWriter contains a pivot table and pivot chart.

 

The query for this report was designed in Visual Studio .NET 2003 and th= en OfficeWriter Designer was used to add rich Excel capabilities to the rep= ort.

Downl= oads

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





 

 

------=_Part_10492_1169174244.1711726419529--