<?xml version="1.0" ?>
<ReportData>
<Table Name="Customer">
<Data>
<CustNum>1</CustNum>
<Country>USA</Country>
<Name></Name>
<Address>276 North Drive</Address>
<Address2></Address2>
<City>Burlington</City>
<State>MA</State>
<PostalCode>01730</PostalCode>
<Contact>Gloria Shepley</Contact>
<Phone>(617) 450-0086</Phone>
<SalesRep>HXM</SalesRep>
<CreditLimit>66700</CreditLimit>
<Balance>903.64</Balance>
<Terms>Net30</Terms>
<Discount>35</Discount>
<Comments>This customer is on credit hold.</Comments>
<Fax></Fax>
<EmailAddress></EmailAddress>
</Data>
<Table Name ="Order">
<Data>
<Ordernum>6</Ordernum>
<CustNum>1</CustNum>
<OrderDate>02/11/98</OrderDate>
<ShipDate>02/16/98</ShipDate>
<PromiseDate>02/16/98</PromiseDate>
<Carrier>Standard Mail</Carrier>
<Instructions></Instructions>
<PO></PO>
<Terms>Net30</Terms>
<SalesRep>HXM</SalesRep>
<BillToID>0</BillToID>
<ShipToID>0</ShipToID>
<OrderStatus>Shipped</OrderStatus>
<WarehouseNum>0</WarehouseNum>
<Creditcard>American Express</Creditcard>
</Data>
<Data>
<Ordernum>8</Ordernum>
<CustNum>1</CustNum>
<OrderDate>02/11/98</OrderDate>
<ShipDate>02/16/98</ShipDate>
<PromiseDate>02/16/98</PromiseDate>
<Carrier>Standard Mail</Carrier>
<Instructions></Instructions>
<PO></PO>
<Terms>Net30</Terms>
<SalesRep>HXM</SalesRep>
<BillToID>0</BillToID>
<ShipToID>0</ShipToID>
<OrderStatus>Shipped</OrderStatus>
<WarehouseNum>0</WarehouseNum>
<Creditcard>American Express</Creditcard>
</Data>
</Table>
</Table>
</ReportData>
please any one help me i need to create this format
i have done but it is not this format. i am using dynamic buffer and dynamic query.
i need to get one customer and all the orders of that customer .
please help me...........
<ReportData>
<Table Name="Customer">
<Data>
<CustNum>1</CustNum>
<Country>USA</Country>
<Name></Name>
<Address>276 North Drive</Address>
<Address2></Address2>
<City>Burlington</City>
<State>MA</State>
<PostalCode>01730</PostalCode>
<Contact>Gloria Shepley</Contact>
<Phone>(617) 450-0086</Phone>
<SalesRep>HXM</SalesRep>
<CreditLimit>66700</CreditLimit>
<Balance>903.64</Balance>
<Terms>Net30</Terms>
<Discount>35</Discount>
<Comments>This customer is on credit hold.</Comments>
<Fax></Fax>
<EmailAddress></EmailAddress>
</Data>
<Table Name ="Order">
<Data>
<Ordernum>6</Ordernum>
<CustNum>1</CustNum>
<OrderDate>02/11/98</OrderDate>
<ShipDate>02/16/98</ShipDate>
<PromiseDate>02/16/98</PromiseDate>
<Carrier>Standard Mail</Carrier>
<Instructions></Instructions>
<PO></PO>
<Terms>Net30</Terms>
<SalesRep>HXM</SalesRep>
<BillToID>0</BillToID>
<ShipToID>0</ShipToID>
<OrderStatus>Shipped</OrderStatus>
<WarehouseNum>0</WarehouseNum>
<Creditcard>American Express</Creditcard>
</Data>
<Data>
<Ordernum>8</Ordernum>
<CustNum>1</CustNum>
<OrderDate>02/11/98</OrderDate>
<ShipDate>02/16/98</ShipDate>
<PromiseDate>02/16/98</PromiseDate>
<Carrier>Standard Mail</Carrier>
<Instructions></Instructions>
<PO></PO>
<Terms>Net30</Terms>
<SalesRep>HXM</SalesRep>
<BillToID>0</BillToID>
<ShipToID>0</ShipToID>
<OrderStatus>Shipped</OrderStatus>
<WarehouseNum>0</WarehouseNum>
<Creditcard>American Express</Creditcard>
</Data>
</Table>
</Table>
</ReportData>
please any one help me i need to create this format
i have done but it is not this format. i am using dynamic buffer and dynamic query.
i need to get one customer and all the orders of that customer .
please help me...........