Video: Using Reporting Services to create Excel Pivot Chart Reports with OfficeWriter
page 2 of 2
by Steven Smith
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 21793/ 47
Article Contents:

  • 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



View Entire Article

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-2024  |  Page Processed at 2024-05-23 1:52:28 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search