Microsoft SQL Server 2008 Reporting Services
Course: SSRPT
Duration: 3 Days
Level: II
Course Summary
This course teaches students the techniques for using SQL Server 2008 Reporting Services. They will learn about tabular and list reports that employ datasets and data regions. This course will also teach students how to add custom expressions, custom functions and format reports using Visual Studio 2008 and SQL Server 2008 Business Intelligence Studio. The reports created in the course will employ shared data sources, interactive sorting, and drill-down capabilities. Students will learn how Reporting Services parameters work and create parameters in ad-hoc SQL. They will also build Matrix reports and charts to help understand the use of Reporting Services gauges. Deployment of Reporting Services projects using a variety of formats and client-side printing will be covered. Students will learn how SSRS Security works for managing user roles and accounts.
« Hide The Details
Topics Covered In This Course
Introducing SQL Server Reporting Services
- Reporting Services overview
- Architecture
- Components
- Basic report using the SQL Server Reporting Services Wizard
Creating Tabular and List Reports
- Tabular report without the wizard
- Dataset usage
- Report textboxes and other controls
- List data regions
Calculation and Formatting
- Expressions
- Custom functions
- Global collections
- Formatting toolbars, the Properties window, and the Textbox Properties dialog box
- Conditional formatting
- Report variables
Grouping and Sorting
- Overview
- Grouping pane
- Group totals and percentages
- Scope as it applies to aggregate functions
- Sorting
- Drill-down reports
Working with Parameters
- Stored procedure parameters
- Parameters in ad-hoc SQL
- Parameter values in report headers
- Parameter prompts using drop-down list parameters
- Unbound, multi-valued, and cascading parameters
- Troubleshooting
Creating Matrix Reports and Charts
Managing Reporting Services
- Plan and configure deployment
- Deploy Reporting Services projects, individual reports and data sources
- Client-side printing
- Report Manager
- Linked reports
Security
- Overview
- User accounts and roles
- Authentication
- SSL
- Credentials within a data source
Programming Reporting Services
- Programming interfaces
- URL to integration
- Report Viewer controls for Web pages
- Local mode options
Advanced Reporting Services Programming
- Reporting Services Web Service API
- Calling the Report Server Web Service
- Custom assembly integration
- Security considerations
Snapshots and Subscriptions
- Report caching
- Scheduling of report snapshots
- Report history
- Standard report subscriptions
- Data-driven report subscriptions
What You Can Expect
At the end of this course, students will be able to:
- Create tabular and list reports
- Build expressions and understand how they are used within SSRS
- Use global, field and parameter collections
- Create Groups using the grouping pane for Details Group and Row Groups
- Use parameters with stored procedures, with values on reports and unbound parameters
- Create Matrix reports and see the new features of Matrix reports for SSRS 08
- Deploy reports and use the report manager
- Use SSRS Security, SSL and Data Source Security
- Use Reporting Services APIs and Report Viewer Controls
- Create a Web Service, a Web Service Subscription and Custom Assemblies
Who Should Take This Course
This course is designed for individuals who are SQL Server 2008 Reporting Services users.
Recommended Prerequisites
Knowledge of SQL Server 2008, SQL Server Management Studio, and SQL usage is highly recommended.
Training Style
Instructor led with 50% lecture and 50% lab.
« Hide The Details
Related Courses
| Code |
Course Title |
Duration |
Level |
|
DSSRPT |
Maintaining, Troubleshooting, and Developing Solutions with Microsoft SQL Server 2008 Reporting Services |
5 Days |
I |
Details |
SSQE |
Microsoft SQL Server 2008 Introduction to Querying |
2 Days |
I |
Details |
SSQFD |
Microsoft SQL Server: Querying Data for Report Developers |
3 Days |
I |
Details |
SSRS1 |
SQL Server Reporting Services with BI Tools Part 1 - Report Builder, Data Tools, Cubes, and Tabular Reporting |
5 Days |
I |
Details |
MSBI |
Accelerated Microsoft Business Intelligence: From SQL 2008 through SharePoint and Office 2007 |
4 Days |
I |
Details |
SSRS2 |
SQL Server Reporting Services with BI Tools Part 2 - Report Server Admin, Extensive Tabular Modeling/Reporting, and C#/VB Extensions |
5 Days |
II |
Details |
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.
|
