AspAlliance.com LogoASPAlliance: Articles, reviews, and samples for .NET Developers
URL:
http://aspalliance.com/articleViewer.aspx?aId=1063&pId=-1
Video: Using Reporting Services to create Excel Pivot Chart Reports with OfficeWriter
page
by Steven Smith
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 24909/ 63

View

[Play the Video] - Requires Registration/Login

Notes
  • 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:
    http://docs.softartisans.com/OfficeWriterWindows/3.0.3/ExcelWriterASP/default.aspx

  • 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 ASPAlliance.com  |  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