Course Overview
Our SQL Server Reporting Services (SSRS) is an instructor-led classroom based training course that teaches attendees how to design and create report, indicators, charts, data bars, lists, map layers and manage these by using SSRS.
Skills Required
Study Path
Delegates might be interested in the following courses too:
Career Path
This is a possible career path after completing this course:
SQL Server Report Designer > Senior SQL Server Report Designer
- Introduction to SSRS
- BIDS and Report Manager
- Solutions and projects
- The 4 main Visual Studio windows
- Designing a Simple Report
- Authoring a report
- Using report items
- Selecting and formatting report items
- Number formats
- Data sources and datasets
- Shared data sources
- Shared versus embedded datasets
- Using Query Designer
- Tables
- Structure of a table
- Formatting tables
- Inserting rows
- Interactive sorting
- Repeating page headers
- Grouping tables
- Using the grouping panes
- Row and column groups
- Displaying subtotals
- Outlining
- Expressions
- Calculated fields
- The ReportItems collection
- Using built-in fields
- Conditional formatting using
- expressions
- Parameters
- Using query parameters
- Creating drop lists
- Multi-value drop lists
- Formatting using parameters
- Indicators
- Creating indicators
- Changing the symbols displayed
- Stopping indicators stretching
- Gauges
- Creating and formatting gauges
- Gauge panels
- Pointers, scales and ranges
- Charts
- The areas of a chart
- Creating charts
- Formatting charts
- Data bars and sparklines
- Need for a grouped row
- Creating data bars
- Creating sparklines
- Lists
- Creating and formatting lists
- Grouping using lists
- Using rectangles in list
- Subreports
- Creating a child report
- Creating the main report
- Creating and formatting subreports
- Maps
- ESRI shapefiles / SQL spatial data
- Linking to datasets
- Map layers
- Center points and point layers
- Deploying Reports