Reporting Services Report Development Fundamentals - Part 1
This course is for report developers new to Reporting Services. It explains the development environment and how to get started building flexible reports.
What you'll learn
This course provides an introduction to Reporting Services for report developers having no prior experience with the product by explaining how to use the development tools effectively, how to present and enhance data in a report, and how to create dynamic reports. The features and demonstrations in this course focus on the SQL Server 2008 R2 release, although most functionality (with the exception of the tablix control) also applies to earlier versions of Reporting Services.
Table of contents
- Introduction 1m
- Data Sources 3m
- Demo: Creating a Data Source 5m
- Datasets 4m
- Demo: Creating a Dataset 5m
- Report Items 2m
- Demo: Adding a Textbox, Image, Line, Rectangle, and Subreport to a Report 9m
- Data Regions 3m
- Table 2m
- Demo: Creating a Table 6m
- Matrix 1m
- Demo: Creating a Matrix 3m
- List 1m
- Demo: Creating a List 4m
- Summary 2m
- Introduction 1m
- Table + Matrix 1m
- Tablix Data Regions 3m
- Demo: Adding Rows and Columns to a Table 7m
- Demo: Adding Rows and Columns to a List 4m
- Demo: Reproducing List Behavior in a Table 5m
- Tablix Cell Contents 2m
- Demo: Working with Cell Contents 8m
- Cell Scope 3m
- Demo: Checking Cell Scope 4m
- Summary 1m
- Introduction 1m
- Expression 3m
- Placeholders 3m
- Demo: Using Placeholders in Expressions 8m
- Global Collections 6m
- Expression Editor 2m
- Demo: Opening the Expression Editor 1m
- Demo: Intellisense and Collection Syntax in the Expression Editor 3m
- Demo: Intellisense and Functions in the Expression Editor 1m
- Demo: Constants, Built-in Fields, and Parameters in the Expression Editor 2m
- Demo: Fields and Datasets Collections in the Expression Editor 1m
- Demo: Operators and Function Categories in the Expression Editor 2m
- Summary 2m
- Introduction 1m
- Expression Usage 2m
- Demo: Creating a Parameter Label 4m
- Demo: Concatenating Field Values with Static Text 1m
- Demo: Conditional Formatting 4m
- Built-in Fields 3m
- Demo: Working with Built-in Fields 3m
- Aggregate Functions 3m
- Scope 3m
- Demo: Using an Aggregation Function with the Scope Argument 4m
- Demo: Using the RunningValue Function and the ReportItems Collection 7m
- Variables 2m
- Demo: Conditional Formatting Based on a Group Variable 7m
- Demo: Working with Report Variables 4m
- Summary 2m
- Introduction 2m
- Linked Reports 1m
- Demo: Creating and Configuring Linked Reports 4m
- Drillthrough and Subreports 2m
- Demo: Configuring a Drillthrough Report 5m
- Parameters in Expressions 1m
- Demo: Using Parameters in Expressions 8m
- Query Parameters 2m
- Demo: Connecting a Report Parameter to a Query Parameter 6m
- Cascading Parameters 1m
- Demo: Building Cascading Parameters 5m
- Summary 2m
About the author
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.