https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/39030.aspxFri, 27 Feb 2009 22:29:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:39030eferron0https://www.infopathdev.com:443/forums/thread/39030.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=39030<p>Any recommendations for the following</p> <p>I have a form library with several form submissions.&nbsp; I cannot promote all the fields in the form to sharepoint columns.&nbsp; I need to query 6 data elements from all the forms so I can do some aggregation of the data.&nbsp; Short of walking every item in the list and read the elements what is the best way to read the data in the form library?</p> <p>My app is a web part running in the same application (site collection) as the form library built&nbsp;with C#.</p> <p>Recommendation?</p> <p>Web Service or Object Model?&nbsp; Which API?&nbsp;</p> <p>Tools/Environment</p> <ul> <li> <div>Windows Server 2003</div></li> <li> <div>MOSS 2007</div></li> <li> <div>InfoPath 2007</div></li> <li> <div>Visual Studio 2008 / .NET Framework 3.5</div></li> <li> <div>Telerik Chart Controls for ASP.NET</div></li></ul> <p>Thanks!</p> <p>&nbsp;Ed</p>