SQL Reporting Services Fundamentals

What is Reporting Service

• Who uses SSRS?
• The 4 main Visual Studio Windows
• Business Intelligence Reporting Solutions

Reporting Services Architecture

• How Reporting Services works
• Reporting Engine Architecture
• Data Tier
• Application Tier
• Server Tier
• SSRS Tools: Report Designer, Report Manager, Reporting Services Configuration Manager
• SSRS Processors & Extensions:Processing & Rendering Extensions (HTML, CSV, XML, Image, PDF, Excel, Word)
• SSRS Delivery Extensions
• SSRS Databases: Report Server, Report ServerTempDB

Report Builder 3.0

• Business Intelligence Design Studio
• SQL Server Data Tools
• SSRS Report Planning
• Designing Reports with Wizards
• Designing Custom Reports
• Authoring a report
• Using report items
• Selecting and formatting report items
• Report Function and Formatting
• Images and Textboxes
• Enterprise Ad-hoc Reports

Advanced Report Design

• Headers and Footers
• Table and Matrix Groups
• Adding Totals to Table and Matrix Reports
• How to create report templates
• Text Boxes, Padding & Embedded Formatting
• Designing Master/Detail Reports
• Creating Drill down reports
• Creating Sub Reports
• Creating Drill through and Link Action Reports
• Navigating Reports:Bookmarks, URLs
• Expression Builder
• Fields!Globals!Paramters! and Report Items
• SSRS Operators:string concatenation, aritmetic, comparison
• SSRS Functions: Maths, String, Data, IIf, Switch
• Conditional Formatting
• Using List Regions to combine Report Items

Report Layout and Formatting

• Report Layout Types:Table, Matrix, List, Chart, Gauge, Dashboard
• Tablix Regions
• Tablix Properties
• Table Groups
• Group Expressions
• Interactive Sort
• Page Breaks
• Drill Downs
• Formatting Report Data
• Dynamic Formatting
• Multicolumn Reports
• Gauge Reports

Implementing Interactive Sorting

• Adding Fixed Headers
• Working with Parameters
• Prompting for User Input
• Using a Report Parameter as a filter
• Using a Dataset for Report Parameter values
• Adding a Query Parameter to a Dataset
• Creating Cascading Parameters
• Displaying Parameter Selections in a Report

Developing Report Models

• Preparing to Develop a Report Model
• Generating a Report Model
• Refining a Report Model
• Managing a Report Model

Review of Deployment Options

• Deploying a Report Project
• Uploading a Report
• Using Rs Utility
• Using Folders to Organise Content
• Creating a Linked Report
• Configuring Data Source Properties
• Configuring Report Execution Properties

Developing Expressions

• Adding Calculations to a Report
• Adding a Calculated Field
• Creating a Text Box Expression
• Using a Report Item Expression
• Using Built In Fields
• Using Aggregate Functions
• Changing Report Item Properties by using Expressions
• Working with Variables
• Using Expressions for Dynamic Connections and Datasets
• Developing Expressions for Hierarchical Data

Navigating around Report Manager

• Organising Reports, Data Sources and Datasets
• Adding Data Cells
• Displaying or Hiding Report Manager Details
• Running Reports
• Managing Folders and Files
• Managing Reports and Data Sources
• Creating a Standard Subscription
• Parts of a Subscription
• Managing Reports and Data Sources
• Managing Site Settings
• Creating Linked Reports
• Managing Generic-site Settings
• Report Caching
• Report Snapshots

Report Security

• Configuring Report Server Security
• Learn basic authentication
• Assigning User Permissions
• Implementing Data Security
• Configuring Report Server Security Policies
• Assigning User Permissions
• Configuring Item-Level Security

Performing Administrative Tasks

• Using Management Tools
• Configuring the Report Server
• Monitoring the Report Server