SQL Server 2005 Reporting Services Workshop

Web Tech, UK
Painswick, Gloucestershire, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This three-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.

You Will Learn How To
Use the reporing wizard to quickly generate reports
Use all features of the report designer
Parameterize reports and queries
Format reports
Administer reporting services
Implement security and undertsand the security model
Use the report builder

Course Content
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

...''

Phone:+44 (0) 1452 814 303

School Address:

The Old Fleece, Bisley St, GLOS GL6 6QQ UK


Jobs & Resumes: Painswick
Houses & Roommates: Painswick

Search other schools for SQL Server 2005 Reporting Services training resources.

C#.NET 2005 - Introduction
C#.NET 2005 - Windows Applications
C#.NET 2005 - ASP Applications
ADO.NET 2.0 with C#
Windows Workflow with C#
XML, XLST and Web Services
XML Development in .NET
.NET Development for Delphi Developers using C#
Delphi 2005 - Upgrade and ASP.NET
SQL Server 2005 for Developers
SQL Server 2005 Analysis Services
Advanced Delphi Development with SQL Server
Delphi Power Programming
Delphi 8 for .NET
ADO with Delphi
Java 2 Programming Fundamentals
Java 2 Advanced Programming
Java Web - Servlets, JSP, Ajax
Java Web Services

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!