|
The
Big Picture
SQL Server
2005 Reporting Services Features | The Reporting Services
Key Components |
Client Components |
Web Components |
Report Server Components |
Database Components |
Report Design Options |
Visual Studio 2005 and Development Studio |
Data Processing Extensions |
Included Extensions |
Custom Data Processing Extensions |
Deployment Options |
Key Considerations |
Distribution Options |
Rendering Extensions
The Reporting Wizard
Starting SQL Server Business Intelligence
Development Studio |
Creating a New Report Project |
Welcome to the Report Wizard Dialog |
Select the Data Source Dialog |
Design the Query Dialog |
Select the Report Type Dialog |
Design the Table or Design the Matrix Dialog | Choose the
Table Layout | Choose Table Style or Matrix Style Dialog
| Completing the Wizard Dialog |
Understanding What Just Happened |
Previewing Reports |
Publishing Reports |
Accessing Reports via the Report Manager
The Report Designer
The Main Components
of the Design Environment | Menus |
Toolbars |
Windows |
Usability Features |
Creating a Data Source and Dataset |
Create a Data Source |
Create a Dataset |
Query tab |
Fields tab |
Data Options |
Parameters |
Filters |
Using the Graphical Query Designer |
Designing the Layout |
The Layout View |
The Toolbox |
Adding a Table Data Region |
Adding Data Fields to a Table Data Region |
A Closer Look at Preview |
Adding Textboxes |
Changing Columns and Rows |
Adding or Deleting |
Resizing |
Moving |
Table Data Region Record Sorting |
Using Expressions |
Using the Expression Editor Dialog |
Grouping Data |
General |
Filters |
Sorting |
Visibility |
Data Output
Query and Report Parameters
Query vs. Report
Parameters | Create a Report Query |
Add Report Parameter to a Dataset |
Previewing a Report with Parameters |
Displaying Parameters in a Report |
Dynamic Parameter Values (From Query)
Formatting Reports
Report Item Style
Properties | Quick Formatting using Toolbar and Menu Options
| Report Formatting Toolbar | Report Borders Toolbar | Formatting
Textboxes with
the Textbox Properties Dialog | General | Visibility | Navigation | Font | Format
| Interactive Sort | Data Output | Managing Tables with the
Table Properties Dialog |
General | Visibility | Navigation
Sorting | Groups | Filters | Data Output | Setting the Report Properties | General
|
Layout | Code | Data Output | Drawing Lines and Rectangles
Administration
Managing Reporting
Services | Using the Report Manager | Settings | Security
| Other | SQL Server Management Studio | Overview | The Management
Studio Object
Explorer | Managing Objects in Object Explorer | Server Properties | Web Folder
Properties | Data Source Properties | Shared Schedules | Using the Reporting
Services Configuration Manager | Tools for Managing Reports | Deploying Reports
with Development Studio | Linked Reports | Managing Parameters
Subscriptions, Snapshots, and Caching
Understanding Subscriptions
| Creating a Subscription | Static Subscription | Data-driven
Subscription | Understanding Snapshots | History Properties
| Understanding
Caching | Execution Properties
Security
Security Model
Concepts | Understanding System-level Roles | Adding System-level
Roles | Understanding Item-level Roles | Adding an Item-Level Role | Understanding
Users and Groups | Understanding Security Settings | Default Folder Structure
|Current Classroom Folder Structure | Adding Groups and Users
| Adding Groups to Reporting
Services | Adding Users | Auditing and Management Reports | Execution Log Reports
| Server Management Reports | Installing Auditing and Management
Reports | Deploying
the Auditing and Management Reports | Deploy Sample Reports to Report Server
| Create a Database for Report Execution Data | Configure
and Run the Job Package |
Run the Sample Reports
Building Report Models
Understand the Report Model Architecture |
Creating a Report Model Project | Creating a Report Model
Data Source | Creating a Data Source View | Modifying
the Data Source View | Toolbar | Diagram Pane | Diagram Organizer Pane | Tables
Pane | Creating a Report Model File | Report Model Generation Rules | Model Statistics
| Understanding the Model Designer | Model Designer Layout|
Entities | Attributes |
Identifying Field | Roles | Entity and Field Folders | Perspectives | Deploying
a Report Model
Using Report Builder
Understanding Report
Builder | Launching Report Builder | Report Builder Design
Layout | Getting Started Pane | Report Toolbar | Explorer Pane | Design Area
| Building a Table Report | Adding Fields to the Table Data
Region | Report Groupings |
Previewing a Report | Formatting | Report Filters | Clickthrough Reports | Saving
a Report | Building a Matrix (Cross-tab) Report | Creating Formulas | Creating
a Chart Report | Parts of the Chart | Chart Types | Chart Options
System Requirements
Installation Instructions
Expression Functions for Development Studio
Formula Functions for Report Builder
|
