Share via


Lesson 4: Creating a Report that Uses XML Data

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

In this lesson, you will create a report that uses data from the Report Server Web service that you retrieved in the previous lessons. In the previous lessons, you created datasets from a variety of XML data sources. To view the data in a report, you need to add fields from the dataset to a data region. In this lesson, you will add a rectangle container, two tables, and a group, format and resize the fields, and preview the report.

To create a report that uses the XML data

  1. In Layout view, drag a rectangle onto the design surface.

  2. Drag a table into the rectangle. Reduce the size of the table.

  3. Drag a second table next to the first one. Reduce the size of the table to fit.

  4. From the Datasets window, drag Name and Path to the second and third columns of the Detail row.

  5. Right-click a row handle and select Insert Group.

  6. In the Grouping and Sorting Properties dialog box, in the Group on text box, select =Fields!Type.Value. Click OK.

  7. Drag Type to the group header row of the first column.

  8. Delete unused footer rows.

  9. Select the table header row, style the text as bold, enlarge the font, and align the text to the left.

  10. Select the group header row, style the text as bold, and specify left alignment.

  11. Select the detail row and specify left alignment.

  12. Resize the columns so that the Name and Path columns are larger relative to the Type column.

  13. Save the file, and then click Preview. The finished report shows the name and path of each item, organized by type.

Next Lesson

This concludes this tutorial about how to retrieve XML data. To learn more about report design or how to retrieve data from other sources, see Designing and Implementing Reports: Tutorials.

See Also

Concepts

Defining Report Datasets for XML Data

Other Resources

How Do I Find Tutorials (Reporting Services)
Tutorial: Creating a Basic Report

Help and Information

Getting SQL Server 2008 Assistance