I am exporting data from a dataset into excel (.xls) format. At the moment this is just a test extract from the Northwind test database consisting of Customer,Orders and Order_Details Tables. What happens when I open excel is that three spreadsheets are created one for each table. However when I export a report from MS Reporting services my data hierarchy is maintained within excel. Could someone advise me on what to do to maintain the data hierarchy when exporting data?