Report with XML data source

[sweety.shah]

Hi

I am working with XML file to create report. It is with header-detail tag. However client need some of xml records into columns instead of rows.

{

<header>

  <dept>

                            <id>1</id>

                            <name>Sales</name>

<product>

    <id>1</id>

    <Quantity>0</Quantity>

    <price>10</price>

</product>

<product>

    <id>2</id>

    <Quantity>1</minQuantity>

    <price>13</price>

</product>

</dept></header>

                             Quantity              Price
Sales                      0                         10

}

 

So, question is how to convert rows into columns with xml data source in between header-detail section. If crosstab or subreport, can you please provide any example or reference links for it. 

 

Quick help is appriciated.

 

Thanks