SQL Server 2005 Reporting Services
Price: $1495
Duration: 3 Days | SQL Server 2005 Reporting Services Course Schedule
Prerequisites: Familiarity with database concepts and Windows desktop navigation. Attendance at SST's 3-day SQL Programming course, or equivalent knowledge, is helpful but not required.
Description: This three-day hands-on course thoroughly covers Microsoft's SQL Server 2005 Reporting Services utility. 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), Analysis Services (SSAS), and Notification Services along with Reporting Services should take the 5-day SQL Server 2005 Business Intelligence Application Development course instead of this course.
Reporting Services Architecture
- Report Server Components Defined
- Review of the Report Server Databases
- Reporting Services Web Service Interface
- Report Lifecycle Step by Step
- Creating Parameter Reports
- Using Cascading and Multi-Select Parameters
- Drill-through Reports
- Linked Reports and Subreports
- Adding Report Maps
- Setting Report Links
- Creating Report Models
- Adding Subtotals and Formulas
- Managing Data Sources
- Publishing Report Models
- Setting up Folders for Users
- Setting Permissions
- Creating Custom Security Roles
- Securing Report Models
- Querying the Report Server
- Creating Custom Data Extensions
- Creating Command Objects
- Creating Data Reader Objects
- Generating Report Definition Language
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
- Creating Matrix Reports
- Adding Data Regions
- Grouping and Sorting on Columns
- Adding Subtotals to Matrix Reports
- Accessing Report Models
- Using the Report Builder
- Filtering Data
- Adding Expressions
- Building a Chart Report
- Creating Snapshot Reports
- Storing Report Histories
- Using Report Caching
- Creating Report Subscriptions
- Rending Reports in Excel, XML or PDF
