|
|
|
|
Beware of the man who knows the answer before he understands the question
|
|
|
|
|
|
|
| |
|
|
Microsoft SQL Server Reporting Services 2014 - Level 1
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 |
|
|
|
|