Reporting Services Advanced Topics
Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Advanced Chart Design- 38m 17s
—Introduction 0m 59s
—Color Palette 1m 55s
—Demo: Creating a Custom Color Palette 2m 0s
—Intervals 2m 17s
—Demo: Adding Intervals to a Line Chart 2m 54s
—Scale Break 1m 9s
—Demo: Adding a Scale Break to a Column Chart 2m 5s
—Empty Points 0m 57s
—Demo: Configuring Empty Points 2m 22s
—Calculated Series 1m 1s
—Demo: Adding a Moving Average to a Column Chart 1m 59s
—Secondary Axis 1m 2s
—Demo: Moving a Series to a Secondary Axis 1m 21s
—Multiple Chart Types 1m 30s
—Demo: Changing the Series Chart Type 1m 3s
—Multiple Chart Areas 1m 57s
—Demo: Assigning a Series to a Separate Chart Area 3m 46s
—Pie Slice Consolidation 2m 41s
—Demo: Working with Pie Slice Properties 3m 23s
—Summary 1m 56sAdvanced Map Design- 34m 49s
—Introduction 0m 55s
—Map Layers 1m 57s
—Map Layer Data Properties 1m 36s
—Map Layer Properties 1m 36s
—Demo: Adding and Configuring a Line Layer 4m 29s
—Demo: Adding and Configuring a Point Layer 3m 16s
—Color Rule Options 2m 4s
—Demo: Working with an Analytical Dataset 2m 58s
—Demo: Applying a filter to an Analytical Dataset 2m 19s
—Map Elements and Viewport Properties 2m 46s
—Demo: Working with Viewport Properties 2m 3s
—Scales and Legends 1m 41s
—Demo: Configuring Legends 3m 9s
—Custom Points 0m 50s
—Demo: Adding a Custom Point 1m 20s
—Order of Precedence 0m 39s
—Summary 1m 11sReporting with Analysis Services- 56m 43sCustom Functions- 25m 51s