-
Beginner
-
Online Classes
-
Total 8 hours in class
Requirements
This course suits those with basic knowledge of Microsoft SQL Server database and table design, SQL, T-SQL and Stored Procedure. Our SQL for Beginners covers all of the prerequisites.
Class Details
Our SQL Server Reporting Services (SSRS) is an instructor-led virtual classroom-based training course that teaches attendees how to design and create reports, indicators, charts, data bars, lists, map layers and manage these by using SSRS.
Course Outline
- 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
- Charts
- The areas of a chart
- Creating charts
- Formatting charts
- Data bars and sparklines
- Need for a grouped row
- Creating data bars
- Creating sparklines
- Gauges
- Lists
- Subreports
- Map Report
- Deploying Reports
Request for Course Dates and Booking
Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:
- book a course on different dates
- book for a group of delegates
- book corporate training
- book a customised training
- book a one-on-one training
The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below: