Hi, does anyone know how to export to xml using sql server reporting service 2008 ? I found it is really hard to do the xml export. I have a sample which i should make my exported xml layout same as this sample. The data in the sample came from sql database. Thanks ! The sample listed as follows: <?xml version="1.0" encoding="utf-8"?> <?xml-stylesheet type="text/xsl" href="Content/Specification.xslt"?> <Specification xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="Content/Specification.xsd"> <OverallDetails> <Title>title1</Title> <Version>0.1</Version> </OverallDetails> <Product> <SimpleProduct name="product1"> <Description>description1</Description> <ProductGroup>group1</ProductGroup> <ProductDetails> <ProductDetailName>Details1</ProductDetailName> </ProductDetails> </SimpleProduct> <SimpleProduct name="product2"> <Description>description2</Description> <ProductGroup>group2</ProductGroup> <ProductDetails> <ProductDetailName>Details2</ProductDetailName> </ProductDetails> </SimpleProduct> </Product> </Specification>

You should be able to set this output using Dataelementname and Dataoutput properties for the table output Read the below thread http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/68e18514-8d3c-445c-9bb7-f2836635fb96 For the report level you should be able to set the schema name with DataSchema property.

Thank you very much !! How to set the output like " <Description>description1</Description>" I only can set the output like "<Tablix10 Description="description1"/>" have been stuck on this for the whole day. Please help, thanks!!

Finally, I figured out how to do that. Actually it is pretty easy, set the text box DataElementStyle to Element