https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/27202.aspxThu, 13 Mar 2008 21:24:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:27202Clay Fox0https://www.infopathdev.com:443/forums/thread/27202.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=27202<p>You have come to the right place :)</p> <p>That is our specialty.</p> <p>Send me an email and I will show you examples of how you can integrate Sharepoint and SQL to have reporting and work flow and filtered lists.</p>https://www.infopathdev.com:443/forums/thread/27200.aspxThu, 13 Mar 2008 19:07:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:27200ltheONEl0https://www.infopathdev.com:443/forums/thread/27200.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=27200<p>The story:</p> <ul> <li> <div>I created an infopath form for purchase orders.</div></li> <li> <div>I published this form to a new document library on our sharepoint</div></li> <li> <div>works great. I got a document library full of XML files, that I can filter via promoted data.</div></li></ul> <p>Now some ungrateful individual wants a summary report based on this data... How dare they</p> <p>I am missing something elementary here I know, but how do I get a dataset object from the XML files stored in the document library?</p> <p>I thought of using an SQL database to store the info, but then I figured I&#39;d loose the best effect of storing in a doc lib; i.e. a list full of completed forms that I can filter.</p> <p>SO</p> <p>I have a document library tipping over with XML data files representing&nbsp;company purchase orders but know way of producing an Excel report for accounts.</p> <p>Can anyone suggest a solution or point me in the correct research direction please?</p> <p>&nbsp;</p>