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.
What you'll learn
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.
Table of contents
- 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
- 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
- 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
- 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
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.