www.visionharvest.com

The Big Picture

• SQL Reporting
  Services Key
  Features
• Report Design
  Options
• Data Extensions
• Deployment Options
• Distribution Options
• Rendering
  Extensions
  

The Report Wizard

• Using Development
  Studio
• Using the Report
  Wizard
• Viewing Reports
• Publishing Reports
• Accessing Reports via
  the Report Manager
• Printing and Exporting
  Reports
  

Creating a Basic
Report

• The Main
  Components of the
  Design Environment
• Creating a Data
  Source and a
  Dataset
• Report Items
• Table Data Region
• Inserting Data Fields
• Inserting Text
• Previewing the
  Report
• Working with the
  Textbox Report Item
• Adding, Resizing and
  Removing Columns
  and Rows

Creating a Basic
Report (cont...)

• Sorting
• Inserting
  Calculations
• Page Numbers and
  the Globals
  Collection
• Summary
  Calculations
• Grouping Data
• Saving Reports
  

Query and Report
Parameters

• Query vs. Report
  Parameters
• Create a Report
  Parameter
• Add Report
  Parameter to
  Dataset
• Specifying Query
  Parameters
• Parameter
  Properties
• Displaying
  Parameter Values in
  a Report
• Multiple Value
  Parameters
• Using Dynamic
  Parameters
  

Formatting Reports

• Quick Formatting
  using the Toolbar
  and Menu Options
• Textbox Style
  Properties
• Table Style
  Properties
• Table Grouping and
  Sorting Properties

Formatting Reports (cont...)

• Margins and other
  Report Layout
  Properties
• Report Header,
  Footer and Body
  Areas
• Page Breaks
• Lines and Boxes
  

Administration

• Using the Report
  Manager to configure
  Reporting Services
• Using the SQL
  Management Studio
  to Configure
  Reporting Services
• Using the Reporting
  Services
  Configuration Tool
• Creating Folders
• Uploading and
  Updating Reports
• Modifying Report
  Properties
• Managing
  Parameters
• Linked Reports

Administration and Development

Subscriptions,
Snapshots and
Caching

• Understanding
  Report Caching and
  Snapshots
• Data Source
  Credentials
• Creating Snapshots
• Scheduling
  Snapshots
• File Share
  Subscriptions
• Email Subscriptions
• Shared Schedules
  

Security

• Security Model
  Concepts
• Roles and Tasks
• Creating New Roles
• Adding Groups and
  Users
• Securing Folders
• Site Settings
• Row Level Security
• Deploying Audit
  Management
  Reports

Building Report
Models

• Report Model
  Architecture
• Create a Report
  Model Project
• Create a Data
  Source
• Create a Data
  Source View
• Modify Data Source
  View
• The Model Designer
  

Using Report Builder

• Launching report
  Builder
• Designer Layout
• Building a Table
  Report
• Report Filters
• Clickthrough Reports
• Building a Matrix
  Report
• Creating Formulas
• Creating a Chart
  Report

Appendix A – System
Requirements

Appendix B –
Installation
Instructions

Appendix C –
Expression
Functions for
Development Studio

Appendix D –
Formula Functions
for Report Builder