Video: Using Reporting Services to create Excel Pivot Chart Reports with OfficeWriter
 
Published: 02 Nov 2006
Unedited - Community Contributed
Abstract
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
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 24912/ 61
Article Contents:

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

 

 



User Comments

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

dbwhisperer.blogspot.com/2008/10/reporting-services-is-fun-again.htm






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


©Copyright 1998-2021 ASPAlliance.com  |  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