XML : Query with XML data source in SSRS

I want to use SSRS (2008) to generate report from xml datasource. What I want to do is as following :

  <Data>  <Element1><value1>some data in element 1</value1></Element1>  <Element2><value2>some data in element 2</value2></Element2>  <Element3><value3>some data in elment 3</value3></Element3>  </Data>      <ElementPath IgnoreNamespaces="true">  Data{}/Element1 {value1}  </ElementPath>    

Do you have any idea how can I get Element1.value1, Element2.value2, and Element3.value3 in the same query ?

Thanks in advance.

Aniss

No comments:

Post a Comment