Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
SQL SERVER 2005 REPORTING SERVICES
SQL Training Overview

In this course, you will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. You will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. You'll gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies. You'll also discover how to integrate reports into your ASP.NET and WinForms applications using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you'll learn how to create ad-hoc reports using Report Builder and Report Model projects.

SQL Training Audience:

SQL Server Users

SQL Training Prerequisites

Familiarity with databases and the SQL language. Knowledge of SQL Server, Visual Studio .NET/2005, C# or VB helpful, but not required.


SQL Training Course duration

3 days

SQL Training Course outline

Introducing SQL Server Reporting Services

  • Tour of Features
  • Reporting Services Architecture and Terminology
  • Reporting Services Editions
  • Taking Reporting Services for a Spin
Creating Reports
  • Deconstructing Reporting Services
  • Shared Data Sources
  • Creating Reports from Scratch
Calculations and Formatting
  • Creating Expressions
  • Using the Global Collections
  • Formatting Items
  • Conditional Formatting
Grouping and Sorting
  • Creating Groups
  • Calculating Totals and Percentages
  • Interactive Sorting
  • Creating Drill-Down Reportss
Report 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
  • Deploying Reports and Data Sources
  • Exporting Reports and Printing
  • Using the Web-Based Report Manager
  • Using SQL Server Management Studio-based Reporting Services Manager
Reporting Services Security
  • Two Parts to Reporting Services Security
  • Securing Access to Reports
  • Data Source Security
Programming Reporting Services
  • The Many Reporting Services APIs
  • Integrating Reporting Services into Applications using URL Access
  • Using the Report Viewer Controls
Advanced Reporting Services Programming
  • Using the Reporting Services Web Service
  • Working with Custom Assemblies
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

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy