SQL Server Reporting Services - SSRS (online)
Course
Online
Description
-
Type
Workshop
-
Level
Beginner
-
Methodology
Online
-
Class hours
12h
-
Duration
2 Days
-
Start date
Different dates available
-
Delivery of study materials
Yes
-
Support service
Yes
-
Personal tutor
Yes
-
Virtual classes
Yes
SQL Server Reporting Services 2008 R2 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 2008 R2 also includes whizzy new report items like indicators, gauges and sparklines. On this three-day course you will use SQL Server 2008 R2 Business Intelligence Development Studio to create reports, and learn how to deploy and export them in various formats. The course will also briefly show how to use Report Builder 3.0 (although superficially different, it is actually almost identical to Reporting Services). Suitable for: This SSRS 2008 R2 course is aimed primarily at businesses and public sector organisations
Important information
Documents
- SSRS course outline.pdf
Facilities
Location
Start date
Start date
About this course
You do not need any prior knowledge of SQL to attend this course (although you should have an understanding of tables and databases).
Reviews
Subjects
- Reporting Services
- Charts
- Simple Reports
- Data source
- Data sets
- Tables
- Expressions
- MAPS
- Subreports
- Grouping
Teachers and trainers (4)
Andrew Gould
Senior Trainer
Andy Brown
Microsoft Trainer & Programmer
Sam Lowrie
Trainer
Shaun Wantling
Trainer
Course programme
- Visual Studio and SQL Server Data Tools
- Solutions and projects
- The Visual Studio environment
- Authoring a report
- Using report items
- Selecting and formatting report items
- Number formats
- Shared data sources
- Shared versus embedded datasets
- Using Query Designer
- Structure of a table
- Formatting tables
- Inserting rows
- Interactive sorting
- Repeating page headers
- Using the grouping panes
- Row and column groups
- Displaying subtotals
- Outlining
- Calculated fields
- The ReportItems collection
- Using built-in fields
- Conditional formatting using expressions
- Page headers and footers
- Pagination between groups
- Header and footer expressions
- Using query parameters
- Creating drop lists
- Multi-value drop lists
- Formatting using parameters
- Creating indicators
- Changing the symbols displayed
- Stopping indicators stretching
- Creating and formatting gauges
- Gauge panels
- Pointers, scales and ranges
- Areas of a matrix
- Sorting and grouping matrices
- Creating and formatting subtotals
- The areas of a chart
- Creating charts
- Formatting charts
- Need for a grouped row
- Creating data bars
- Creating sparklines
- 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
- 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
- Setting the target server
- Deploying an entire project
- Deploying single reports
- 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
Additional information
SQL Server Reporting Services - SSRS (online)