Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500.

Reporting Services Architecture

• All Report Server Components Defined
• Review of the Report Server Databases
• Managing the Report Manager Web Interface
• Report Lifecycle Step by Step

Creating Basic Reports

• Creating Table Reports
• Formatting Options
• Adding Headers and Footers
• Using Subtotals and Formulas
• Adding Charts and Gauges
• Using Lists for Free-Form Reports
• Paging and Sorting
• Managing Data Sources

Matrix Reports

• Pivoting Data with Matrix Controls
• Adding Multiple Data Regions
• Grouping and Sorting
• Adding Subtotals
• Adding Custom Aggregate Formulas
• Using the TablixControl

Advanced Report Features

• Setting Up Input Parameters
• Adding Custom Report Navigation
• Adding Drill-Down for Master-Detail Reports
• Linking Reports
• Using Sub-reports
• Adding Conditional Formatting

Reporting Services Security

• Organizing Reports in Folders
• Setting Permissions on Reports and Folders
• Managing Security Roles
• Securing Data Sources and Report Models
• Logging Activity on the Report Server

Adding Custom Code

• Querying the Report Server
• Creating Custom Data Extensions
• Creating Command Objects
• Creating Data Reader Objects
• Generating Report Definition Language

• Report Builder Utility

• Creating Reports with Report Builder
• Connecting to Report Models
• Adding Charts and Gauges in Report Builder
• Differences Between SQL Server Data Tools and Report Builder

• Automating Report Creation and Delivery

• Creating Snapshot Reports
• Storing Previous Versions of Reports
• Caching Reports to Improve Performance
• Defining Subscriptions to Automate Report Delivery
• Rending Reports in Excel, MS Word or as a PDF
• Hiding Reports from Users