Skip to main content

Event Review: Advanced SQL Server 2005 Reporting Services (Session ITPROSQL-07)

Welcome to the material supporting page for this session. The materials on this page have been selected as the best matches to the content covered in the live event session.

Session Outline

See advanced techniques for building reports with Microsoft SQL Server 2005 Reporting Services and the Microsoft Visual Studio-based Report Designer. Topics in this sessions include: how to use the built-in expression language, report parameterization (data driven, multi-valued, and hierarchical), supporting multiple data sources (including relational, multi-dimensional, and XML), and making reports interactive. Learn about the new features in Microsoft SQL Server 2005 for report designers, receive a walk-through of sample reports and discover tips and tricks for using the Report Definition Language (RDL).

Session Agenda

  • New Data Sources in SSRS 2005
  • Reporting Services Data Extensions
  • Working with SSAS and SSIS Data
  • End-User Sort and Parameterization
  • Schedules and Subscriptions

Related Links

Use the following resources to learn more about topics covered in this briefing.

Microsoft Press Books

  • Microsoft SQL Server 2005 Administrator's Pocket Consultant

    Summary: Portable and precise, this pocket-sized guide delivers immediate answers for the day-to-day administration of SQL Server 2005.

  • Microsoft SQL Server 2005 Reporting Services Step by Step

    Summary: Your hands-on, step-by-step guide to building reporting solutions for the enterprise. Teach yourself the fundamentals of SQL Server Reporting Services one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that support the reporting needs of your organization. Discover how to: Install and configure Reporting Services , Author, manage, and access reports, Create attractive, information-rich reports with the Report Designer, Calculate values, organize information, and manipulate report data, Build, deploy, and maintain a report model, Render and distribute reports in various formats, Implement role-based security to restrict access to information, Explore more advanced report design techniques, Programmatically customize any stage of the reporting lifecycle. The included CD features all practice exercises.

Third-Party Books

  • SQL Server 2005 Distilled

    Summary: SQL Server 2005 Distilled offers realistic insight into every significant aspect of SQL Server 2005: its new features, architecture, administrative tools, security model, data management capabilities, development environment, and much more.

  • Microsoft SQL Server 2005 A Beginner's Guide

    Summary: This bestselling beginner's guide gets users up and running on SQL Server 2005. The book covers database concepts, and discusses key topics for new users including the SQL Server Workbench, T-SQL, automated administration tasks, security, and analysis.

  • Microsoft SQL Server 2005 The Complete Reference

    Summary: Filled with practical solutions and real-world examples, this resource includes full details on: Enterprise data management capabilities, including security and clustering Powerful developer tools -- T-SQL, .NET CLR, XML, ADO.NET 2.0 Business Intelligence features, such as Integration Services, data warehousing, and reports.

  • Professional SQL Server 2005 Reporting Services

    Summary: SQL Server Reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly so you can design, deploy, manage, and even customize reporting solutions. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET. Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of this revolutionary tool.

Training and Certification