Reporting Services Report Development Fundamentals -Part 2
This course is for report developers new to Reporting Services and explains how to work with charts, maps, pagination, and interactive features
What you'll learn
This course continues building on the foundation established in the Reporting Services Fundamentals course. It explains how to work with all of the data visualization features in the SQL Server 2008 R2 release of Reporting Services, including charts, data bars, sparklines, gauges, and maps. It also explains features for pagination in print-ready reports and for interactivity in online reports.
Table of contents
- Introduction 2m
- Introduction to Charts and Chart Types 5m
- Chart Data Pane 1m
- Demo: Creating a Column Chart 5m
- Chart Elements 2m
- Demo: Configuring Chart Element Properties 10m
- Data Bars 4m
- Demo: Adding a Data Bar to a Tablix 6m
- Sparklines 2m
- Demo: Designing a Sparkline 3m
- Gauges 3m
- Demo: Working with a Gauge 6m
- Indicators 1m
- Demo: Configuring an Indicator 6m
- Summary 2m
- Introduction 1m
- Spatial Data Types 2m
- Points 1m
- Bing Maps Integration 2m
- Lines 1m
- Polygons 1m
- Spatial Data Sources 3m
- Map Wizard Overview 2m
- Select a Spatial Data Source 1m
- Configure Map View Options 1m
- Select a Map Type 2m
- Specify an Analytical Dataset 1m
- Set Data Visualization Options 2m
- Demo: Using the Map Wizard with the Map Gallery 8m
- Demo: Modifying Map Properties 4m
- Demo: Using an ESRI ShapeFile 3m
- Demo: Adding a Point Layer 4m
- Summary 2m
- Introduction 1m
- Rendering 5m
- Demo: Rendering 5m
- Render Format 2m
- Demo: Using the RenderFormat Variable 5m
- Page Structure 2m
- Demo: Working with Pagination Properties 3m
- Page Header and Footer 1m
- Soft Page Breaks 1m
- Demo: Understanding Soft Page Breaks 2m
- Logical Page Breaks 2m
- Demo: Configuring Logical Page Breaks 2m
- Page Name 1m
- Page Numbers 1m
- Demo: Setting Page Name and Page Number Properties 4m
- Repeating Headers 1m
- Demo: Configuring Repeating Headers 3m
- Summary 3m
- Introduction 1m
- Interactive Sorting 2m
- Demo: Sorting Detail Rows by Group Across the Data Region 2m
- Demo: Sorting Detail Rows Within a Single Group 1m
- Demo: Sorting Groups 2m
- Fixed Headers 1m
- Demo: Configuring Fixed Headers 2m
- Tooltips 1m
- Demo: Adding a Tooltip Expression to a Textbox 3m
- Visibility 2m
- Demo: Creating a Drilldown Report 4m
- Document Map 1m
- Demo: Defining Document Map Labels 2m
- Actions - Bookmarks 1m
- Actions - Go To Report 1m
- Actions - Go To URL 1m
- Demo: Setting Up Bookmarks 3m
- Embedded HTML 1m
- Demo: Using HTML Tags to Include E-Mail Links in a Report 2m
- 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.