MS2030 - Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services
| Categories |
Microsoft SQL Server Reporting Services Training, Reporting Training |
| Duration |
2 days (14 hours) |
| Pre-requisites |
Experience with databases and programming and exposure to Visual Studio .NET is helpful but not requred. |
|
|
|
| Courseware |
MS2030-MS (200 pages) |
| Price |
$790 |
| Notes |
This course is intended for database administrators, database developers, IT professionals, and partners who have a minimum of six months SQL Server 2000 and SQL Server 7.0 experience and basic Microsoft Visual Studio .NET navigation skills.
|
This two-day Microsoft SQL Server 2000 Reporting Services course will teach database
professionals and developers how to successfully author, deploy, and manage reports in their organization using Microsoft Reporting Services. This Microsoft SQL Server 2000 Reporting Services training course provides a good understanding of how to apply reporting services to problems within a business context. After completing this course, students will be able to understand the architecture of Microsoft Reporting Services and Office integration, author reports using the Report Designer, deploy and publish reports, and manage the lifecycle of a report including report scheduling and backup and restore.
Module 1: Introduction to Microsoft SQL Server Reporting Services
Overview of Microsoft SQL Server Reporting Services
Tour of Reporting Services
Overview of Reporting Services Architecture
Describe the reporting lifecycle
Describe the key features of Reporting Services
Describe the process of report delivery
Describe the authoring process
Describe the process of managing reports
Describe the Reporting Services platform
Describe Reporting Services components and software prerequisites
Describe single server deployment
Describe Web farm deployment.
Module 2: Authoring Basic Reports
Creating a Basic Table Report
Formatting Report Pages
Calculating Values
Use Report Designer.
Describe the options for creating a report
Describe the purpose of Report Definition Language
Access data using a data source and a data set
Create a table
Create groups
Describe the report page structure
Add items to a report
Create report headers and footers
Create new fields based on data set fields
Create expressions as the value of individual text boxes
Use aggregate functions
Describe the common aggregate functions
Use conditional expressions to create dynamic formatting
Module 3: Enhancing Basic Reports
Interactive Navigation
Displaying Data
Allow the user to navigate to an appropriate level of detail
Create a document map
Create links and custom report actions
Describe the data regions available within the Report Designer
Create a table data region
Create a chart data region
Create a list data region
Create a matrix data region
Choose data regions for a particular report
Create a subreport data region
Module 4: Manipulating Data Sets
Defining Report Data
Using Parameters and Filters
Connect to a data source
Describe why report parameters are used
Use report parameters
Use query parameters
Describe the use of filters
Create a data filter
Pass parameters to a stored procedure
Create a dynamic parameter list
Allow the user to display all items in a data set
Simulate the effect of a multi-select parameter list
Module 5: Managing Content
Publishing Content
Executing Reports
Creating Cached Instances
Creating Snapshots and Report History
Publish a report using the Report Designer
Publish a report using Report Manager
Update a data source
Update a report
Configure report properties
Describe the process of report execution
Describe how a report on-demand is executed
Describe how session caching works
Create a linked report
Describe the processing steps when executing a cached report
Describe the use of query parameters on a cached instance
Describe the use of filters on a cached instance
Configure a cached instance of a report
Describe how a snapshot report is executed
Use query parameters on a snapshot report
Use filters on a snapshot report
Configure a snapshot report
Describe the purpose of report history
Configure report history
Describe the purpose of subscriptions
Create a standard subscription
Create a data-driven subscription
Module 6: Administering Reporting Services
Server Administration
Performance and Reliability Monitoring
Database Administration
Security Administration
Describe the Report Server configuration files
Assign security accounts for the Report Server
Describe the purpose of the Report Server trace files
Configure the level of tracing
View report execution log information
Utilize Report Server performance counters
Apply timeouts to long-running queries or reports
Suspend jobs
Describe how Report Server stores information
Estimate required disk space for a Report Server installation
Define a backup and restore strategy
Describe the Report Server authorization model
Assign roles
Modify and create item-level roles
Secure individual items using roles
Modify and create system-level roles
Secure the Report Server site
Module 7: Programming Reporting Services
Querying Server Information
Automating Report Management
Rendering Reports
Creating Custom Code
Describe Web services
Describe what information is available using the Report Server Web service
Retrieve server information using the Report Server Web service
Describe report management automation
Automate tasks using Web services
Automate tasks using scripting
Render reports from a Web page
Render reports programmatically using the Report Server Web service
Describe Reporting Services extensions
Describe the uses for custom assemblies