Markgoldin wrote:
> Yes, you are right. Here it is:
> <?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
> <VFPData>
>  <tree menuid="91" parentid="24" name="Adam Briel" link=" 
> " salesrepid="670" category="4" exclude="true" comments="true"/>
>  <tree menuid="83" parentid="24" name="Betty Mazon" link=" 
> " salesrepid="325" category="4" exclude="true" comments="true"/>
>  <tree menuid="93" parentid="24" name="Christina Martinez" link=" 
> " salesrepid="625" category="4" exclude="true" comments="true"/>
>  <tree menuid="48" parentid="20" name="Current Inventory" salesrepid="0" 
> category="4" exclude="true" comments="true"/>
>  <tree menuid="67" parentid="20" name="Customer Details" salesrepid="0" 
> category="4" exclude="true" comments="true"/>
>  <tree menuid="61" parentid="20" name="Customer Order Status" 
> link="http://ufd-sql2008test/ReportServer?%2fCustomerPoStatus&amp;rs:Command=Render&amp;rc:Parameters=false&amp;rc:Zoom=100&amp;ccustno=&amp;SalesOrder=&amp;CustomerPO=&amp;Sku=&amp;OrderDate=&amp;ShipDateFrom=&amp;ShipDateTo= 
> " salesrepid="0" category="4" exclude="true" comments="true"/>
>  <tree menuid="24" parentid="20" name="Customer Reporting" salesrepid="0" 
> category="4" exclude="true" comments="true"/>
>  <tree menuid="20" parentid="1" name="Customer Service" salesrepid="0" 
> category="4" exclude="true" comments="true"/>
>  <tree menuid="62" parentid="20" name="Pick Plan Status" 
> link="http://ufd-sql2008test/ReportServer?%2fPPStatus&amp;rs:Command=Render&amp;rc:Parameters=false&amp;rc:Zoom=100&amp;ccustno= 
> " salesrepid="0" category="4" exclude="true" comments="true"/>
>  <tree menuid="50" parentid="48" name="Price Lists" salesrepid="0" 
> category="4" exclude="true" comments="true"/>
>  <tree menuid="55" parentid="20" name="Product LookUp" 
> link="http://ufd-sql2008test/ReportServer?%2fCustserviceOpenOrders&amp;rs:Command=Render&amp;rc:Parameters=false&amp;rc:Zoom=100&amp;ccustno= 
> " salesrepid="0" category="4" exclude="true" comments="true"/>
>  <tree menuid="47" parentid="48" name="Sku Attributes Reporting" 
> link="http://ufd-sql2008test/ReportServer?%2fskuattributesFG&amp;rs:Command=Render&amp;rc:Parameters=false&amp;rc:Zoom=100&amp;ExcludeOnHand= 
> " salesrepid="0" category="4" exclude="true" comments="true"/>
>  <tree menuid="49" parentid="48" name="Sku Price List Preparation" 
> salesrepid="0" category="4" exclude="true" comments="true"/>
>  <tree menuid="95" parentid="24" name="Susan Finnane" link=" 
> " salesrepid="375" category="4" exclude="true" comments="true"/>
>  <tree menuid="1" name="United Feather and Down" salesrepid="0" category="0" 
> exclude="true" comments="true"/>
>  <tree menuid="90" parentid="24" name="Yoori Lee" link=" 
> " salesrepid="650" category="4" exclude="true" comments="true"/>
> </VFPData>
> 
> Sure, I could add an extra column "folder". But how would I know in advance 
> which node is a parent?

So that is the XML, a flat list of 'tree' element nodes. How do you 
determine that something is a folder? If the 'link' attribute value is 
an empty string?


-- 

	Martin Honnen --- MVP XML
	http://msmvps.com/blogs/martin_honnen/