Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Beware of the man who knows the answer before he understands the question
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

Microsoft SQL Server Reporting Services 2014 - Level 1

2 days


On completion of this course delegates will be able to design and deliver Analytical Business and Management Information reports, using Microsoft SQL Server Reporting Services.

Target Audience: This course is designed for report designers, new to SQL Reporting Services, who are responsible for the creation and distribution of business and management reports.

Pre-requisites: Delegates must be able to use a Microsoft Windows and a mouse


Introduction to SQL Reporting Services and SQL
Overview of SQL Reporting Services
Overview of SQL Commands
The SELECT clause
The FROM clause
The WHERE clause
The ORDER BY clause
The GROUP BY clause
The HAVING clause

Creating Report Projects
Creating Report Projects
Creating Shared Datasources
Creating Shared Datasets

Working with Report Projects
Adding New Reports to the Report Project
Creating Report Datasource
Creating Report Dataset
Adding Existing Reports to Report Projects
Removing Reports from Report Projects

Working with Tablix Data Regions
Adding Tablix Report Items
Adding Fields to the Tablix
Adding Columns to Tablix
Deleting Columns from Tablix
Working with Tablix Rows
Adding Groups to Tablix
Adding Totals and Subtotals to Tablix

Formatting Reports
Applying Basic Formatting
Using the Properties to Format Report Items
Working with Page Headers and Page Footers
Adding Graphical Report Items
Changing the Page Properties

Working with Expressions
Using Expressions in Reports
Creating Calculated Fields
Working with Report Item Collections
Working with Aggregate Functions
Using Expressions to Control Report Behaviour
Using Conditional Formatting

Working with Parameters
Overview of Parameters
Creating Simple Parameters
Creating Multivalue Parameters
Creating Parameter Datasets
Defining Parameter Properties
Using Parameters to Filter Reports
Creating Expressions with Parameter Fields
Using Parameters to Conditionally Format Reports

Working with Chart Data Regions
Overview of Chart Data Regions
Overview of the Report Properties
Changing the Report Background Properties
Creating Simple Bar Chart
Creating Simple Pie Chart
Adding Report Comments
Formatting Charts

Working with Report Properties


If you require a tailored course click here