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
Note
When reviewing tutorials, it is recommended you add Next and Previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.
See Also
Concepts
Other Resources
Defining Report Datasets for XML Data
Working with Data in Reporting Services
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
17 July 2006 |
|
14 April 2006 |
|