Request infopath form library
Is there a tool that allows you to query (and aggregate data) a library of infopath forms in MOSS? I cannot use promoted fields as some of the items I want to query are repeated in groups that cannot be promoted (AFAIK). So I have to query for basic XML.
I realize I can write my own code that iterates through the forms and does an xpath query for each one, I'm just wondering if there is an existing tool or functionality for this?
source to share
You can use the lists.asmx web service to retrieve XML and work with it in Reporting Services, or even Excel.
Take a look at using XML as a data source in SQL Reporting Services
if you export the list to a spreadsheet, you will also be able to work just like any other spreadsheet. It all depends on what you want to do with the information and where it will end up.
You can also look at data binding to the dundas charts web part
source to share