This two-day, interactive workshop is designed for new users of Microsoft SQL Server Reporting Services 2005. Some of the topics covered include a review of the software features, administrative tasks, report design, creation of presentation quality reports, and report deployment. The course incorporates a number of hands-on exercises to reinforce the learning process.
SQL Training Audience:
Developers new to SQL Reporting Services, SQL DBAs, and IT management.
SQL Training Prerequisites
Familiarity with Visual Studio 2005 is helpful, but not required.
SQL Training Course duration
2 days
SQL Training Course outline
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 Report 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
Appendix A – System Requirements
Appendix B – Installation Instructions
Appendix C – Expression Functions for Development Studio
Appendix D – Formula Functions for Report Builder
