Doelgroep
De cursus SQL 2005 Server Reporting Services is bedoeld voor die personen die vanuit hun database(s) met SQL 2005 Server Reporting Services rapporten willen genereren, beheren, distribueren en bekijken.
Voorkennis
Men werkt al geruime tijd met de computer en is bekend met databases en het genereren, beheren en distribueren van databaserapportages.
Cursusduur
2 x 6 uur (1 dag per week).
Doelstelling / Resultaat
In de cursus SQL 2005 Server Reporting Services aanleren van onderstaande vaardigheden en deze effectief leren toe te passen. Daarbij wordt nadrukkelijk aandacht besteed aan het verkrijgen van inzicht in de structuur en opbouw van het programma, alsmede de achterliggende ontwerptechnieken en het publiceren middels SQL Report Server.
Na afloop van de cursus SQL 2005 Server Reporting Services is de cursist in staat te werken met deze techniek. U bouwt rapporten en leert hoe u informatie uit de database selecteert en in een rapport verwerkt. Verder gaat u in deze cursus in op het beschikbaar maken, presenteren en distribueren van rapporten naar groepen gebruikers.
Offerteaanvraag
Klik hier voor een vrijblijvende offerteaanvraag over de cursus SQL 2005 Server Reporting Services.
CURSUSINHOUD
PART ONE: GETTING STARTED WITH REPORTING SERVICES
MODULE 1: UNDERSTANDING REPORTING
Reporting Scenarios
Reporting User Communities
The Enterprice Reporting Life Cycle
Reporting Services Components
MODULE 2: INSTALLING REPORTING SERVICES
Considering Deployment Options
Preparing for Installation
Installing Reporting Services
MODULE 3: BUILDING YOUR FIRST REPORT
Authoring a Report
Managing a Report
Accesing a Report
PART TWO: AUTHORING REPORTS
MODULE 4: DEVELOPING BASIC REPORTS
Understanding a Report Defenition File
Preparing a Report Using Report Designer
Sructuring a Report Using Report Designer
Formatting a Report Using Report Designer
MODULE 5: WORKING WITH EXPRESSIONS
Using Expressions to Calculate Values
Using Aggregate Functions
Using Expressions to Change an Object’s Behavior
MODULE 6: ORGANIZING DATA IN REPORTS
Understanding Data Regions
Using a Matrix
Using a Chart
Using a List
MODULE 7: BUILDING ADVANCED REPORTS
Using Parameters to Change Report Data
Linking Information with Interactive Features
Working with Hierarchical Data
MODULE 8: BUILDING REPORT MODELS
Understanding Report Models
Creating a Report Model
Modifying a Report Model
Managing a Report Model
PART THREE: MANAGING THE REPORT SERVER
MODULE 9: MANAGING CONTENT
Publishing Reports
Organizing Content
Using Properties to Manage Report Content
Managing Report Execution
MODULE 10: MANAGING SECURITY
Using Report Server Security
Applying Data Security
MODULE 11: MANAGING SERVER COMPONENTS
Configuring Reporting Services
Managing the Report Server
Administering Reporting Services Databases
PART FOUR: DELIVERING REPORTS
MODULE 12: ACCESSING REPORTS
Finding and Viewing Reports
Saving Reports for Future Referencs
MODULE 13: RENDERING REPORTS
Comparing Rendering Formats
Rendering for Online Viewing
Rendering for Document Management
Rendering for Data Exchange
MODULE 14: MANAGING SUBSCRIPTIONS
Creating a Standard Subscription
Creating a Data-Driven Subscription
Managing Subscriptions
MODULE 15: CREATING REPORTS WITH REPORT BUILDER
Building Basic Reports
Enhancing Reports
PART FIVE: PROGRAMMING REPORTING SERVICES
MODULE 16: REPORT AUTHORING WITH CUSTOM DEVELOPMENT
Using Custom Code
Creating Custom Data Processing Extentions
Generating Report Definition Language
MODULE 17: PROGRAMMING REPORT SERVER MANAGEMENT
Understanding Web Services
Using a Custum Application to Manage Reporting Services
Using the ReporterServices WMI Provider
MODULE 18: BUILDING CUSTOM REPORTING TOOLS
Using URLs
Using the Web Service
