Video: Using Reporting Services to create Excel Pivot Chart Reports with OfficeWriter
Published: 02 Nov 2006
Unedited - Community Contributed
This video demonstrates how to use Microsoft SQL Server Reporting Services to create Excel Pivot Table and Pivot Chart reports using SoftArtisans OfficeWriter. [14:19]
by Steven Smith
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 24912/ 61
Article Contents:


[Play the Video] - Requires Registration/Login


  • For an introduction to Reporting Services, please watch the SQL Server Reporting Services 2005 Tutorial before this video.
  • For more information on using OfficeWriter, please refer to their online documentation and samples:

  • This video covers the following tasks:
    • Write a SQL query to retrieve data from a database
    • Create a SSRS .rdl report using this data, returning a matrix view
    • Open the .rdl file in Excel using OfficeWriter and create a Pivot Chart and Pivot Table
    • Deploy and View the report using Reporting Services, and rendering the report in Excel with live data.
    • Add a parameter to the original Reporting Services report using a separate data source
    • Revisiting the original report, showing how Excel now prompts the user for the requested parameter prior to rendering the Pivot Table and Pivot Chart



User Comments

Title: programmer   
Name: rami alnajjar
Date: 2010-07-04 8:40:53 AM
iam very happay fro this producut
Title: Much easier now in 2008   
Name: Michael Swart
Date: 2008-11-15 1:20:15 AM
I've got a similar video showing how it's done in 2008. The new Report builder 2.0 is pretty sweet.

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2021  |  Page Processed at 2021-12-05 6:10:49 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search