Reporting Services Advanced Topics

This course is for report developers who have some experience developing reports with Reporting Services. It explains advanced techniques for working with data visualizations, Analysis Services as a data source, and custom functions.
Course info
Rating
(170)
Level
Advanced
Updated
Jan 24, 2011
Duration
2h 36m
Table of contents
Advanced Chart Design
Introduction 1m Color Palette 2m Demo: Creating a Custom Color Palette 2m Intervals 2m Demo: Adding Intervals to a Line Chart 3m Scale Break 1m Demo: Adding a Scale Break to a Column Chart 2m Empty Points 1m Demo: Configuring Empty Points 2m Calculated Series 1m Demo: Adding a Moving Average to a Column Chart 2m Secondary Axis 1m Demo: Moving a Series to a Secondary Axis 1m Multiple Chart Types 2m Demo: Changing the Series Chart Type 1m Multiple Chart Areas 2m Demo: Assigning a Series to a Separate Chart Area 4m Pie Slice Consolidation 3m Demo: Working with Pie Slice Properties 3m Summary 2m
Advanced Map Design
Introduction 1m Map Layers 2m Map Layer Data Properties 2m Map Layer Properties 2m Demo: Adding and Configuring a Line Layer 4m Demo: Adding and Configuring a Point Layer 3m Color Rule Options 2m Demo: Working with an Analytical Dataset 3m Demo: Applying a filter to an Analytical Dataset 2m Map Elements and Viewport Properties 3m Demo: Working with Viewport Properties 2m Scales and Legends 2m Demo: Configuring Legends 3m Custom Points 1m Demo: Adding a Custom Point 1m Order of Precedence 1m Summary 1m
Reporting with Analysis Services
Introduction 1m Query Designer - Design Mode 2m Query Designer 1m Toolbar 2m Demo: Building a Basic Query 6m Query Designer - Query Mode 1m Demo: Working in Query Mode 6m Extended Field Properties 1m Demo: Using the FormattedValue Property 2m Demo: Adding Formatting Properties to a Cube 3m Configuring Font Properties with Extended Field Properties 1m Aggregate Function 2m Demo: Using the Aggregate Function 5m Asymmetrical Queries and Aggregations 1m Demo: Working with an Asymmetrical Query 3m Demo: Using Aggregations Directly from the Cube 2m Calculated Members 1m Demo: Adding a Calculated Member to a Dataset 4m Parameters 2m Demo: Creating Parameters 4m Calendar Control 1m Demo: Working with the Calendar Control 4m Summary 2m
Custom Functions
Introduction 1m Embedded Code 2m Code Property 1m Example Function and Usage 1m Demo: Developing and Using Embedded Code 7m Custom Assembly 2m Custom Assembly Implementation 1m Version Numbering 1m Custom Assembly Reference 1m Custom Assembly Usage 1m Demo: Developing and Using a Custom Assembly 7m Summary 1m
Description
Course info
Rating
(170)
Level
Advanced
Updated
Jan 24, 2011
Duration
2h 36m
Description

This course covers advanced topics in Reporting Services for report developers having some experience with the product. It provides in-depth coverage of data visualization properties and techniques for presenting data visually in charts and maps. It also explains how working with Analysis Services as a data source is different from working with relational sources and shows how to query Analysis Services cubes and how to work with parameters and the report layout when using cube data. This course also shows how report developers can extend Reporting Services functionality by adding custom functions to reports. The features and demonstrations in this course focus on the SQL Server 2008 R2 release, although the custom functions topic also applies to earlier versions of Reporting Services.

About the author

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT