SSRS XmlDP
Hello All,
I need to retrieve the value of a node which is like this
<Sales>
<Id>1</Id>
<Books> This is collection
<Book>
<BookId>1</BookId>
<BookName>C#</BookName>
</Book>
<Book>
<BookId>2</BookId>
<BookName>C++</BookName>
</Book>
</Books>
<Employee>XYZ</Employee>
</Sales>
I wish to retrive all the values along with the Employee Name How should I write the xmlDP query
Thanks,
Narendra
|