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.
Authored by:
Stacia Misner
Duration: 4h 48m
Level: Beginner
Released: 12/14/2010
Features:
Duration: 4h 48m
Level: Beginner
Released: 12/14/2010
Features:
Course Rating:
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using: {{getCurrentPlayerName()}} [Change]
| expand all | collapse all | Progress | Duration | |
|---|---|---|---|
Introduction to Business Intelligence Development Studio |
|
00:23:40 | |
|
Introduction
|
|
00:58 | |
|
Report Development Process
|
|
02:44 | |
|
Report Projects in BIDS
|
|
02:35 | |
|
Project Commands
|
|
02:56 | |
|
Project Properties
|
|
01:44 | |
|
Demo: Working with Projects in BIDS
|
|
10:26 | |
|
Summary
|
|
02:17 | |
Basic Report Development |
|
00:49:47 | |
|
Introduction
|
|
00:56 | |
|
Data Sources
|
|
03:24 | |
|
Demo: Creating a Data Source
|
|
05:10 | |
|
Datasets
|
|
04:22 | |
|
Demo: Creating a Dataset
|
|
05:17 | |
|
Report Items
|
|
01:42 | |
|
Demo: Adding a Textbox, Image, Line, Rectangle, and Subreport to a Report
|
|
08:32 | |
|
Data Regions
|
|
02:33 | |
|
Table
|
|
01:32 | |
|
Demo: Creating a Table
|
|
06:25 | |
|
Matrix
|
|
01:19 | |
|
Demo: Creating a Matrix
|
|
02:38 | |
|
List
|
|
00:40 | |
|
Demo: Creating a List
|
|
03:45 | |
|
Summary
|
|
01:32 | |
Tablix Concepts |
|
00:38:57 | |
|
Introduction
|
|
00:59 | |
|
Table + Matrix
|
|
01:02 | |
|
Tablix Data Regions
|
|
02:51 | |
|
Demo: Adding Rows and Columns to a Table
|
|
07:08 | |
|
Demo: Adding Rows and Columns to a List
|
|
03:34 | |
|
Demo: Reproducing List Behavior in a Table
|
|
05:26 | |
|
Tablix Cell Contents
|
|
02:29 | |
|
Demo: Working with Cell Contents
|
|
07:40 | |
|
Cell Scope
|
|
02:39 | |
|
Demo: Checking Cell Scope
|
|
03:41 | |
|
Summary
|
|
01:28 | |
Matrix Grouping |
|
00:28:33 | |
|
Introduction
|
|
00:43 | |
|
Grouping in a Matrix Layout
|
|
01:15 | |
|
Demo: Adding Groups to a Tablix
|
|
03:01 | |
|
Row Groups
|
|
01:09 | |
|
Demo: Creating Repeating Groups
|
|
05:43 | |
|
Static Columns
|
|
01:03 | |
|
Demo: Creating Static Columns and Static Rows
|
|
08:27 | |
|
Adjacent Groups
|
|
00:59 | |
|
Demo: Creating Adjacent Groups
|
|
04:12 | |
|
Summary
|
|
02:01 | |
Introduction to Expressions |
|
00:33:18 | |
|
Introduction
|
|
00:58 | |
|
Expression
|
|
03:00 | |
|
Placeholders
|
|
02:52 | |
|
Demo: Using Placeholders in Expressions
|
|
07:46 | |
|
Global Collections
|
|
05:38 | |
|
Expression Editor
|
|
01:54 | |
|
Demo: Opening the Expression Editor
|
|
00:40 | |
|
Demo: Intellisense and Collection Syntax in the Expression Editor
|
|
02:45 | |
|
Demo: Intellisense and Functions in the Expression Editor
|
|
01:13 | |
|
Demo: Constants, Built-in Fields, and Parameters in the Expression Editor
|
|
01:43 | |
|
Demo: Fields and Datasets Collections in the Expression Editor
|
|
01:16 | |
|
Demo: Operators and Function Categories in the Expression Editor
|
|
01:35 | |
|
Summary
|
|
01:58 | |
Using Expressions |
|
00:48:53 | |
|
Introduction
|
|
01:08 | |
|
Expression Usage
|
|
01:41 | |
|
Demo: Creating a Paramater Label
|
|
03:35 | |
|
Demo: Concatenating Field Values with Static Text
|
|
01:25 | |
|
Demo: Conditional Formatting
|
|
04:23 | |
|
Built-in Fields
|
|
02:36 | |
|
Demo: Working with Built-in Fields
|
|
02:31 | |
|
Aggregate Functions
|
|
03:22 | |
|
Scope
|
|
02:34 | |
|
Demo: Using an Aggregation Function with the Scope Argument
|
|
04:14 | |
|
Demo: Using the RunningValue Function and the ReportItems Collection
|
|
07:04 | |
|
Variables
|
|
01:37 | |
|
Demo: Conditional Formatting Based on a Group Variable
|
|
06:46 | |
|
Demo: Working with Report Variables
|
|
03:59 | |
|
Summary
|
|
01:58 | |
Introduction to Parameters |
|
00:25:46 | |
|
Introduction
|
|
01:12 | |
|
Report Parameters
|
|
02:22 | |
|
Report Parameter Properties
|
|
04:05 | |
|
Demo: Configuring a Report Parameter with Static Values
|
|
05:26 | |
|
Report Parameter as a Filter
|
|
02:50 | |
|
Demo: Filtering with a Report Parameter
|
|
04:32 | |
|
Demo: Using a Dataset for Report Parameter Values
|
|
03:05 | |
|
Summary
|
|
02:14 | |
Using Parameters |
|
00:39:20 | |
|
Introduction
|
|
01:35 | |
|
Linked Reports
|
|
01:26 | |
|
Demo: Creating and Configuring Linked Reports
|
|
04:26 | |
|
Drillthrough and Subreports
|
|
01:43 | |
|
Demo: Configuring a Drillthrough Report
|
|
04:37 | |
|
Parameters in Expressions
|
|
01:24 | |
|
Demo: Using Parasmeters in Expressions
|
|
08:05 | |
|
Query Parameters
|
|
02:15 | |
|
Demo: Connecting a Report Parameter to a Query Parameter
|
|
06:12 | |
|
Cascading Parameters
|
|
00:42 | |
|
Demo: Building Cascading Parameters
|
|
05:09 | |
|
Summary
|
|
01:46 |
Introduction to Business Intelligence Development Studio