SQL Server Reporting Services

Duration: 3 Days | Price: $1495 | Class Dates:

Students Will Learn:

Rendering Reports in Multiple Formats
Managing Security of Reports and Report Models
Automating the Creation and Delivery of Reports

Generating Reports
Creating Report Models
Customizing Reports

Course Description: This three-day hands-on course thoroughly covers Microsoft's SQL Server Reporting Services utility, including SQL Server 2005 features as well new features of SQL Server 2008. It begins with an overview of the Reporting Services architecture, and then it walks students through creating reports of all types. This includes parameter reports, drill-through reports, matrix reports (pivot tables) and linked reports. It also covers how to create Report Models, which allow end users to create their own ad-hoc reports. The security model of Reporting Services is reviewed, as well as how to schedule the automatic generation and distribution of reports. Finally, writing code to fully customize reports and their generation is discussed.

Students who are also interested in other Business Intelligence Services including Integration Services (SSIS) and Analysis Services (SSAS) along with Reporting Services should take the 5-day SQL Server Business Intelligence Application Development (SSRS, SSIS, SSAS) course instead of this course.

Course Prerequisites: Familiarity with database concepts and Windows desktop navigation. Attendance at HOTT's 3-day SQL Programming course, or equivalent knowledge, is helpful but not required.

SQL Server Reporting Services Course Overview:

Reporting Services Architecture Report Server Components Defined Review of the Report Server Databases Reporting Services Web Service Interface Report Lifecycle Step by Step		Creating Basic Reports Creating Table Reports Formatting Options Adding Headers and Footers Using Subtotals and Formulas Using Charts Working with Lists Paging and Sorting Managing Data Sources Using Gauges
Advanced Report Features Creating Parameter Reports Using Cascading and Multi-Select Parameters Drill-through Reports Linked Reports and Subreports Adding Report Maps Setting Report Links		Matrix Reports Creating Matrix Reports Adding Data Regions Grouping and Sorting on Columns Adding Subtotals to Matrix Reports Using Tablix Regions
Implementing Report Models Creating Report Models Adding Subtotals and Formulas Managing Data Sources Publishing Report Models		Report Builder Utility Accessing Report Models Using the Report Builder Filtering Data Adding Expressions Building a Chart Report Using Report Builder 2.0 in SQL Server 2008
Reporting Services Security Setting up Folders for Users Setting Permissions Creating Custom Security Roles Securing Report Models		Automating Report Creation and Delivery Creating Snapshot Reports Storing Report Histories Using Report Caching Creating Report Subscriptions Rending Reports in Excel, XML or PDF Rendering Reports as Word Documents
Adding Custom Code Querying the Report Server Creating Custom Data Extensions Creating Command Objects Creating Data Reader Objects Generating Report Definition Language		.NET Integration with Reporting Services Writing User-Defined Functions Report Functions Using Custom Functions Referencing .NET Libraries Creating and Building Libraries Managing Report Servers from .NET Applications Accessing SSRS from .NET Applications Retrieving Report Items Listing Report Metadata Using the ReportViewer Control in .NET Applications

Student Testimonials

"The instructor's real-world examples and the hands-on exercises definitely helped clarify concepts. He knows the material very well."
– J.F., UT Southwestern

Multiple Training Locations - Convenience and Cost Control

Regularly Scheduled Courses in more than 75 Cities Across North America and the United Kingdom

Northeast/New England	Southeast	Midwest	West/Southwest	Canada	United Kingdom
CT - Hartford CT - New Haven CT - Stamford DC - Washington MA - Boston MA - Chelmsford MA - Quincy MA - Springfield MA - Waltham MA - Woburn MA - Worcester MD - Baltimore MD - Columbia NH - Manchester NH - Nashua NJ - Jersey City NJ - Newark NJ - Princeton NY - Albany NY - Binghamton NY - Buffalo NY - Ithaca NY - Manhattan NY - Rochester NY - Syracuse PA - Harrisburg PA - Philadelphia PA - Pittsburgh RI - Providence	AL - Huntsville FL - Fort Lauderdale FL - Jacksonville FL - Miami FL - Orlando FL - Pensacola FL - Sarasota FL - Tampa FL - West Palm Beach GA - Atlanta GA - Savannah LA - Shreveport NC - Charlotte NC - Raleigh-Durham NC - Winston-Salem SC - Charleston VA - Alexandria VA - Fairfax VA - Norfolk VA - Richmond VA - Williamsburg	AR - Little Rock IA - Cedar Rapids IA - Des Moines IL - Chicago IL - Schaumburg IL - Springfield IN - Indianapolis KY - Louisville MI - Detroit MI - Lansing MN - Minneapolis MO - Kansas City MO - St. Charles MO - Springfield NE - Omaha OH - Cincinnati OH - Cleveland OH - Columbus OH - Dayton OK - Oklahoma City OK - Tulsa TN - Memphis TN - Nashville WI - Milwaukee	AZ - Phoenix AZ - Tucson CA - Bakersfield CA - Fresno CA - Irvine CA - Los Angeles CA - Modesto CA - Oakland CA - Riverside CA - Sacramento CA - San Diego CA - San Francisco CA - San Jose CA - Santa Clarita CA - Santa Monica CA - Temecula CO - Denver ID - Boise NM - Albuquerque NM - Las Cruces NV - Las Vegas OR - Portland TX - Austin TX - Corpus Christi TX - Dallas TX - El Paso TX - Fort Worth TX - Houston TX - San Antonio UT - Salt Lake City WA - Seattle WA - Spokane	AB - Calgary AB - Edmonton BC - Vancouver MB - Winnipeg QC - Montreal QC - Quebec City ON - Kingston ON - Mississauga ON - Ottawa ON - Toronto SK - Regina	Birmingham Bristol Chelmsford Edinburgh Glasgow Leeds Liverpool London Manchester

Hands On Technology Transfer, Inc.
1 Village Square, Suite 8
14 Fletcher Street
Chelmsford, MA 01824
1-800-413-0939 | 1-978-250-4299