SharePoint Rangers - SQL Server 2008 Reporting Services Training
Schedule Your SharePoint Training Now
Aivea SQL Server 2008 Reporting Services Training
Customer Service Rating by LivePerson
Curve

Other Ways to Reach Us

For General Comments and questions. contact Aivea at
1-800-779-7506 or email us
at sales@aivea.com
Phone
Curve

This course is for Architects, Developers and Administrators who are responsible for developing or maintaining SQL Server Reporting Services reports.


Introduction to SQL Server Reporting Services
Before you can start working on SQL Server Reporting Services, you need to understand how it fits into the overall SQL Server Reporting Services architecture.

  • SQL Server Reporting Services architecture overview
  • Report Server Components
  • Review of the Report Server Databases
  • Reporting Services Web Service Interface
  • Report Lifecycle Step by Step


Creating Reports

 

  • Creating Reports from Scratch
  • Shared Data Sources
  • Creating Expressions
  • Using the Global Collections
  • Formatting Items
  • Conditional Formatting


Grouping and Sorting

  • Creating Groups
  • Calculating Totals and Percentages
  • Interactive Sorting
  • Creating Drill-Down Reports


Reporting Parameters

  • Creating Report Parameters
  • Creating Drop-Down Parameters
  • Multi-Valued Parameters
  • Debugging Parameter Issues


Creating Matrix Reports and Charts

  • Creating a Basic Matrix Report
  • Matrix Subtotals
  • Creating a Basic Chart
  • Exploring the Charting Possibilities


Managing Reporting Services

  • Creating a Basic Matrix Report
  • Matrix Subtotals
  • Creating a Basic Chart
  • Exploring the Charting Possibilities


Reporting Services Security

  • Two Parts to Reporting Services Security
  • Securing Access to Reports
  • Data Source Security


Programming Reporting Services (ASP.NET / Forms)

  • Reporting Services APIs
  • Integrating Reporting Services into Applications using URL Access
  • Accessing SSRS from .NET Applications
  • Using the ReportViewer Control in .NET Applications and SharePoint
  • Using the Reporting Services Web Service

Snapshots and Subscriptions

  • Caching and Snapshots
  • Creating Standard Subscriptions
  • Creating Data-Driven Subscriptions
  • Managing Subscriptions


Ad-Hoc Reporting with Report Builder

  • The Report Builder Architecture
  • Creating Report Model Projects
  • Running Report Builder


Please contact an Aivea SQLTraining Sales Professional at sales@aivea.com or call 1-800-779-7506  to Register or to get a no obligation needs assessment and proposal for your Microsoft SQL Server training needs.