I'm pretty much a novice with InfoPath, but I'm trying to use InfoPath 2003 to facilitate reporting of data pulled from SharePoint (MOSS). I've successfully created the data connections and pulled the data into InfoPath, but would like to take the flat data structure from SP and lay it out in a more 'Grouped' fashion. I assume that I'll use repeating sections, but have been unsuccessful in completing getting the layout quite right. The current data structure in SharePoint looks like this:
_Job #_ _Task_ _Start_Date_ _Comp_Date_
123 BuyParts 01/1/09 02/01/09
123 SortParts 02/02/09 02/10/09
123 Build 02/11/09 02/19/09
789 BuyParts 03/1/09 03/01/09
789 SortParts 04/02/09 04/10/09
789 Build 04/11/09 04/19/09
Would like to have that data retrieved by InfoPath form and displayed as follow:
_123_
BuyParts 01/1/09 02/01/09
SortParts 02/02/09 02/10/09
Build 02/11/09 02/19/09
_789_
BuyParts 03/1/09 03/01/09
SortParts 04/02/09 04/10/09
Build 04/11/09 04/19/09
Any help provided would be much appreciated.