Can someone please give me a pointer? Any SQL or XQuery examples would be very helpful.
I am using the Sql2005 June CTP and trying to use the native xml type with reporting services.
Given the example data below, how do I set up reporting services to report on each property?
I am confused to how I should set up my data source. Can reporting services iterate over the results of XQuery? Or do I need to return a rowset of SQL varchar? Thanks for any help.

<node id="1" type="organization">
<properties>
<property>
<description>Organization Name</description>
<value>Athletic Association</value>
</property>
<property>
<description>City</description>
<value>Detroit</value>
</property>
<property>
<description>State</description>
<value>MI</value>
</property>
</properties>
</node>