Publishing to SharePoint 2003, then getting the data back out

[Terese]

I'm having a problem after I publish an infopath 2003 form to a form library
in SharePoint 2003.

The form publishes fine, and the filled out forms are saved to the library
correctly. The problem is getting detailed data back out of the form. For
example, for each employee I have a long list of training courses and dates
completed. How can I get this detailed info back out of the SharePoint form
library for use in reports? I am limited to 16 date-format columns in
SharePoint. I need to be able to eventually index the dates (add a year to
each one) and build an alert system--hopefully, in SharePoint.

Any suggestions?

Thanks

 

[Clay Fox]

Hi Terese,

This is a common scenario. That I have the solution for. Aggregating your
data for reporting and analysis.

Send me an email and I can show you how this is done.
http://www.infopathdev.com/members/clayfox.aspx

 

[Gavin McKay]

Hi Terese,

SharePoint is quite nasty to get reports out of. There is now a couple of
3rd-party products that can be used to report on SharePoint data - a quick
search should find those on the web. There wasn't any when I needed one
desparately last year lol

The solution I used then was to put the Xml data directly into a SQL server
database, and then run standard reports on them. You could either extract
the data from the Xml and put it in a "standard" database table, or even put
the Xml directly into an Xml data type if you have SQL 2005. Putting it in a
standard database table makes it much easier to report on however.

Gavin.