Printing an XML file!

[FOR111]

Hi all,

Ok now i got stuck with this problem.

I have a search function which shows the search results in a DataGridView (yes .Net 2005). The selected rows are then saved in a XML File on the local HD. So far so good. Now i need that the xml file to be transformed on any reporting tool available even HTML and be automatically printed.

The xml file looks something like this:

 <SearchIndex>
   <Row>
     <search name="ID" value="20" />
     <search name="Index No." value="S345" />
     <search name="Name" value="Nicky Formosa" />
     <search name="Description" value="This is a long description" />
   </Row>
 </SearchIndex>

So, there are obviusly multiple rows similar to the one above. The name is equal to the Column Header, and i would also like to omit the first <search> ie the ID.

Is there a way where i can get a report printed out in a table formated manner!?

Thanks
Nick