SSRS Training
Intensive fast-track 3-day Reporting Services (SSRS)
3 days
Sometimes our clients want to learn everything about SSRS (SQL Server Reporting Services) in one go, minimising the amount of time spent out of the office. We've combined all of the units from our Introduction to SSRS course and the most useful ones from our Advanced SSRS course to create this intensive three-day course, aimed at the select class of people (you'll know if you're one of them) who aren't fazed by the prospect of an intensive three-day period of training. We only offer this as a tailored course (here's why).
Our fast-track courses are only available as tailored training, either at your premises or at either our London or Manchester venues (here's why).
Course Contents
This fast-track course combines topics from the following other Wise Owl courses:
Introduction to SSRS
Visual Studio and SQL Server Data Tools- Solutions and projects
- The Visual Studio environment
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
Pages and printing
- Page headers and footers
- Pagination between groups
- Header and footer 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
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
If time
Lists
- Creating and formatting lists
- Grouping using lists
- Using rectangles in lists
If time
Subreports
- Creating a child report
- Creating the main report
- Creating and formatting subreports
Drill-through reports
- Parent and child reports
- Creating actions
- Passing values to a child report
If time
Maps
- ESRI shapefiles / SQL spatial data
- Linking to datasets
- Map layers
- Center points and point layers
Deploying reports
- Setting the target server
- Deploying an entire project
- Deploying single reports
The SSRS web portal
- Browsing to the web portal
- Viewing reports
- Managing reports
If time
KPIs and mobile reports
- Creating a KPI
- Installing Mobile Report Publisher
- Creating a mobile report
If time
Subscriptions
- How subscriptions work
- Creating a new subscription
- Managing subscriptions
Advanced expressions
- Understanding scope
- Using RowNumber
- Running totals
Variables
- How variables work
- Report variables
- Group variables
Embedding code
- Setting code for a report
- Calling functions in expressions
- Better ways to write code
Using SQL views
- Why views are a good idea
- Designing views
- Scripting views
- Creating virtual tables
Stored procedures in SSRS
- Pros and cons of stored procedures
- Server Explorer vs SSMS
- Creating and editing procedures
- Using for reports
Stored procedure parameters
- Creating report parameters
- Refreshing fields
- Default and null values
Dropdowns with procedures
- The stored procedures needed
- Cascading dropdowns
- Replacing SELECT A VALUE
If time
Multivalue parameter procedures
- Splitting the choices made in SQL
- Displaying the chosen data
- Restricting the number of choices
Improving report navigation
- Document maps
- Using bookmarks
- Setting tooltips
Dynamic reports
- Dynamic datasets
- Dynamic grouping
- Dynamic matrices
You don't need any pre-existing knowledge of SQL or SQL Server to attend this course, although if you understand how databases are constructed using tables and relationships you'll have a head start. What you must have is a very good aptitude for IT, otherwise you won't enjoy your three days!
Why Choose Us?
No more than 6 people per class- Proper restaurant lunch included
- 503 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
David Tayleur (Central and North West London (CNWL) NHS Foundation Trust)
Melanie Utteridge (Easton and Otley College)
Gareth Clubb (Crown Commercial Service)
Simran Seehra (Liberty Speciality Markets)
Laura Page (Shazam Entertainment Limited)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Related Courses
Other Reporting Services training resources
SSRS exercises
We've published our SSRS exercises on our website, so you can see what we will include on your course.
View SSRS 2016 exercises
SSRS videos
As an alternative (or supplement) to classroom training, we've created a series of SSRS videos.
View Reporting Services - Introduction, SSRS 2016, Report Builder 2016 or Reporting Services - Advanced videos
