Tutorial: Using XML Data in a Report

New: 5 December 2005

This tutorial provides step-by-step instructions on how to retrieve XML data for a Reporting Services report using the XML data processing extension. In this tutorial, you will specify a data source connection to the Report Server Web service, create a dataset and query that retrieves XML data, and create and preview a final report.

Requirements

Your system must have the following installed to use this tutorial:

• SQL Server 2005 Reporting Services. Support for the XML data processing extension is not available in SQL Server Express Editions. For more information, see Features Supported by the Editions of SQL Server 2005.

  Note

  To complete this tutorial, you must be running Reporting Services in native mode. If you are running Reporting Services in SharePoint integrated mode, the steps that use report server URLs will not work. For more information about Reporting Services modes, see Deployment Modes for Reporting Services. For more information about deploying projects, see Deploying Reports, Models, and Shared Data Sources to a SharePoint Site.

• Business Intelligence Development Studio.

  Note

  Business Intelligence (BI) Development Studio is not supported on Itanium-based computers. However, support for BI Development Studio is available for x64-based computers. If the SQL Server sample databases have been deployed on an Itanium-based computer, use BI Development Studio on either an x86-based or x64-based computer to modify and run the samples.

• A report server that stores a variety of reports, models, shared data sources, and folders. The XML data that you retrieve in this tutorial is metadata about items stored on a report server. You must have at least one or two stored items so that you have data to report on. One way to quickly add a variety of reports and data sources is to publish the sample reports. For more information, see AdventureWorks Report Samples.

• A Web service that returns an XML System.Data.DataSet object. The XML data that you retrieve in lesson 3 of this tutorial is the XML System.Data.DataSet returned by a Web Service. You can use any Web service available to you that returns a System.Data.DataSet or you can build and deploy the example Web service described in Lesson 2 that retrieves data from the AdventureWorks database.

• For an XML data source, credentials must be configured for either Windows integrated security or no credentials. Remember that if you disable Windows integrated security, you cannot use it to retrieve data. If you specify stored or prompted credentials, an error will occur at run time. For more information, see Defining Report Datasets for XML Data.

Estimated time to complete this tutorial: 30 minutes

Tasks

Lesson 1: Defining a Report Dataset for a Reporting Services Web Service

Lesson 2: Defining a Report Dataset for an ADO.NET DataSet from a Web Service

Lesson 3: Defining a Report Dataset from Embedded XML Data

Lesson 4: Creating a Report that Uses XML Data

See Also

Concepts

Reporting Services Tutorials

Other Resources

Defining Report Datasets for XML Data
Working with Data in Reporting Services

Help and Information

Getting SQL Server 2005 Assistance

Change History