LogoASPAlliance: Articles, reviews, and samples for .NET Developers
Video: Using Reporting Services to create Excel Pivot Chart Reports with OfficeWriter
by Steven Smith
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 24909/ 63


[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



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