.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk floridaC# training course UKC#.net training course UKvb.net training course UKSQL Server training course UK.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida
.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk floridaDelphi training course UKASP.net training courseJava training course UKASP.NET training class UK.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida

C#.Net training

VB.Net training

SQL Server training

ADO.NET training

ASP.net training

Delphi training

Java training

Web Tech, UK
+44 (0) 1452 814 303

Web Tech, USA


Quick Search:

If you have three or more developers needing this course consider having us customize this course for your specific needs - at your site or ours.

SQL Server Course : SQL Server Reporting Services Course in UK

SQL Server Reporting Services
Next Course Dates Call for schedule
3 days


Familiarity with Visual Studio is helpful, but not required

Who Should Attend?
Developers new to SQL Reporting Services, SQL DBAs, and IT management
Course Benefits

This three-day, interactive workshop is designed for new users of Microsoft SQL Server Reporting Services. 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 Reporting Services Features | The Reporting Services Key Components | Client Components | Web Components | Report Server Components | Database Components | Report Design Options | Visual Studio 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

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

Copyright 1990 - 2013 - WebTech Training & Development - C#.net training vb.net training SQL Server training Delphi training ASP.net training Java training UK


home ] contact ] courses ] register ]