Publishing to SharePoint 2003, then getting the data back out

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Terese - 10 Apr 2008 00:19 GMT

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

Reply to this Message

Clay Fox - 10 Apr 2008 04:16 GMT

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

Signature

Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum

> I'm having a problem after I publish an infopath 2003 form to a form library
> in SharePoint 2003.
[quoted text clipped - 10 lines]
>
> Thanks

Reply to this Message

Gavin McKay - 10 Apr 2008 10:32 GMT

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.

Signature

2B | !2B

> I'm having a problem after I publish an infopath 2003 form to a form library
> in SharePoint 2003.
[quoted text clipped - 10 lines]
>
> Thanks

Reply to this Message