SQL Server Reporting Services

Introduction to SQL Reporting Services
(Prerequisite: Introduction to SQL or equivalent experience.) Learn to create professional-quality reports from SQL Server and other ODBC-compliant databases. Discover how to create both standard and ad-hoc reports and deliver them via print, Web, e-mail, and PDF files. Find out how you can create an environment that allows users to design their own reports with limited database knowledge. Learn to build and format reports with headers, footers, titles, totals, and calculations. The reports you create can contain tables, charts (or both), and can drill-down to other reports for greater detail. [Table of Contents]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0546 Mon., Nov. 16West CountyAndrew Schwartz
G0820 Wed., Feb. 10West CountyAndrew Schwartz
Intermediate Applications of SQL Reporting Services
(Prerequisite: Introduction to SQL Reporting Services and Intermediate Applications of SQL or knowledge of joins, or equivalent experience.) Learn to create sophisticated reports that are customized for your specific needs. This course shows you how to display multiple data sets on one report and combine graphics with and without data for visual impact. Other topics include using multi-value parameters and preparing matrix (cross-tab) reports with drill- down capabilities. Learn how to protect your data through model item security, security filters, and opaque expressions. Generate practical reports that display the information needed for decision-making. [Table of Contents]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0547 Tues., Nov. 17West CountyAndrew Schwartz
G0821 Thurs., Feb. 11West CountyAndrew Schwartz
Advanced Applications of SQL Reporting Services
(Prerequisite: Intermediate Applications of SQL Reporting Services or equivalent experience.) Learn the techniques to make your reports more flexible and efficient. Topics include creating drill-down reports to display detail, either from other reports or from charts, and using lists for flexibility in arranging data on reports. Discover how subreports can increase your efficiency by reusing code, allow you to display reports inside the current report, and enable use of multiple data sources. Learn about report delivery methods, including subscriptions and attachments to addresses in an e-mail list. [Table of Contents]
Fee: $239

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0548 Wed., Nov. 18West CountyAndrew Schwartz
G0822 Fri., Feb. 12West CountyAndrew Schwartz