IntelligentOrange

IOSQL101
Nombre del Evento: Microsoft SQL Server 2008 Reporting Services
Incluye: Material Guia.
Intensidad Horario: 14 Horas
Consultores: Conoce nuestros consultores Clic Aqui

Conviertete en nuestro partner y obtiene muchos beneficios, descuentos.

Acceso a nuestros cursos, Nuestros simuladores.

Afiliate ya!!
Mayores Informes:
Andrea Luna
Cel: 317 657 0806

---

Detalles del Curso

1. Objetivos del Curso
2. Requisitos del Curso
3. Temario
4. Nuestros Clientes

---

1. Objetivos del Curso

Los objetivos del curso SQL Server Reporting Services, son: Administrar y gestiónar Microsoft SQL Server Reporting Services. Crear, diseñar y trabajar con cualquier tipo de informe. Realizar tareas de instalación y configuración así como tareas de administración rutinarias como puede ser gestionar la seguridad.

2. Requisitos del Curso

Experiencia en SQL Server, principalmente en puntos como Lenguaje de consultas SQL y Gestión de la seguridad en SQL Server, también sería importante contar con conocimientos del Agente SQL Server.

3. Temario

Introducing SQL Server Reporting Services

• Investigate what SQL Server Reporting Services can do

Explore the basic architecture of SQL Server Microsoft SQL Server 2008 Reporting Services

• Reporting Services
• Gain a basic understanding of the components behind SQL Server Reporting Services
• Learn how to create a basic report using the SQL Server Reporting Services Wizard

Creating Tabular and List Reports

• Learn how to create a tabular report from scratch
• Learn about datasets and data regions
• Discover how to add textboxes and other controls to reports
• Investigate the list data region
• Learn how to work with rich text to produce mail merge style reports

Calculation and Formatting

• Explore how to create expressions in your reports using
• Learn how to create custom functions using the Code window
  • Discover the various global collections that you can reference in your expressions
  • Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box
  • Find out how you can use conditional formatting to make your reports more dynamic
• Learn about report variables and when you might need to use them

Grouping and Sorting

• Explore creating groups
• Master the Reporting Services Grouping pane
• Learn how to calculate group totals and percentages
• Understand scope as it applies to aggregate functions
• Discover interactive sorting
• Find out how to create drill-down reports

Working with Parameters

• Understanding how Reporting Services parameters work with stored procedure parameters
• Learn how to create parameters in ad-hoc SQL
• Find out how to display parameter values in report headers
• Discover how to improve parameter prompts using drop-down list parameters
• Dig into the use of unbound, multivalued, and cascading parameters
• Learn how to solve common parameter issues

Creating Matrix Reports and Charts

• Learn how to create matrix reports
• Investigate Reporting Services charts
• Explore the use of Reporting Services gauges

Managing Reporting Services

• Understand how to plan and configure for deployment
  • Learn how to deploy Reporting Services projects and individual reports and data sources
  • Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services
• Investigate how to manage Reporting Services projects using Report Manager
• Explore creating linked reports

Security

• Investigate how Reporting Services secures access to reports and other

Reporting Services resources

• Find out how to use Report Manager to manage user accounts and roles
• Learn how to enable basic authentication for reports and how to require SSL for report operations
• Explore the storing of credentials within a data source

Programming Reporting Services

• Discover the many application programming interfaces of Reporting Services
  • Learn how to use URL to integrate Reporting Services reports into your applications
• Explore the use of the Report Viewer controls to create Web pages and

Windows Forms that render Reporting Services reports in place

• Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services

Advanced Reporting Services Programming

• Discover the classes and methods exposed by the Reporting Services Web

Service API

• Learn how to call the Report Server Web Service
• Investigate how to call a custom assembly from a report
  • Explore the potential deployment and security issues that might arise when working with custom assemblies

Snapshots and Subscriptions

• Learn how to enable and control report caching
• Investigate the scheduling of report snapshots
• Explore the maintenance of report history
• Discover how to create standard report subscriptions
• Learn how to create data-driven report subscriptions

Ad-Hoc Reporting with Report Builder 2.0

• Learn the differences between Report Builder 1.0 and Report Builder 2.0
  • Explore how to use Report Builder to build ad-hoc tabular, matrix and chart reports
• Discover how to create Report Builder reports without using the wizards
  • Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server

4. Nuestros Clientes

Próximo >