Reporting Services training course (2 days)
SQL Server Reporting Services is THE way to publish reports to your corporate intranet. Not only can you include tables of data, matrices (you may know these as pivot tables), charts, lists and subreports, but SSRS also includes whizzy new report items like indicators, gauges and sparklines. On this two-day course you will use SQL Server 2008 R2 Business Intelligence Development Studio or SQL Server 2012 Data Tools (they sound different, but underneath the hood are virtually identical) to create reports, and learn how to deploy and export them in various formats.
Reporting Services training - Course Contents
The contents of our Reporting Services course are as follows (any items marked with a * will be covered if time allows):
Introduction to SSRS 2008
- 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
- Using Query Designer
- Shared versus embedded datasets
Tables
- Structure of a table
- Interactive sorting
- Repeating page headers
- Inserting rows
- Formatting tables
Grouping tables
- Using the grouping panes
- Row and column groups
- Outlining
- Displaying subtotals
Expressions
- Calculated fields
- The ReportItems collection
- Using built-in fields
- Conditional formatting using expressions
Pages and printing
- Page headers and footers
- Header and footer expressions
- Pagination between groups
Parameters
- Using query parameters
- Creating drop lists
- Multi-value drop lists
- Formatting using parameters
Indicators
- Changing the symbols displayed
- Stopping indicators stretching
- Creating indicators
Gauges
- Creating and formatting gauges
- Gauge panels
- Pointers, scales and ranges
|
Matrices
- Areas of a matrix
- Sorting and grouping matrices
- Creating and formatting subtotals
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 lists
Subreports (*)
- Creating a child report
- Creating the main report
- Creating and formatting subreports
Deploying to Report Manager
- Choosing a target folder
- Ways to deploy reports
Using Report Manager
- Creating folders
- Using Report Manager
- Moving and deleting reports
Subscriptions
- How subscriptions work
- Creating a new subscription
- Managing subscriptions
Maps (*)
- ESRI shapefiles / SQL spatial data
- Linking to datasets
- Map layers
- Center points and point layers
|
Click on any link above to show free exercises for the topic in question. You do not need any prior knowledge of SQL to attend this course (although you should have an understanding of tables and databases). There will be a maximum of 6 people on each course, and each person will have their own computer.
