Currently have a client that we built a SharePoint 2007 web part that displays Active Directory user name, company, title and extension and it's filtered by location and last name initials.  All the LDAP queries were built in a .NET Class project and exposed through a .NET Web Service.  This was all great but I wanted a simple way to display the data in a table format during testing so I decided to use InfoPath 2007 as the presentation layer.  To get it to work was simply done by created a Data Connection to my web service and then inserting the repeating group from web service data source to the form as a repeating table.  Then I clicked the preview button and all Active Directory user information was returned after a short period of time.

The web service was built to accept three parameters (company name, last name initial and title) and I wanted to add the capability to the form to submit the parameters dynamically to test performance of the LDAP query.  To accomplish this I added three textboxes and a button to the form and then created a rule for the button to set the web service data source parameters with the corresponding textboxes and then execute a query to retrieve the results whenever the button was pressed.  All this was accomplished within in minutes and that started me to think about what else could be done simply.

Before I could think about it, my patient, understanding lovely wife came into the office and said she was ready for dinner, so off we went.  Driving to dinner it came to me that I could just publish the form to SharePoint 2007 and display it through the XMLFormView web part so it can inherit the look and feel of SharePoint site.  After returning from dinner this was accomplished by converting my data connection and publishing it the Site Collection Data Connection Library, tiding up the form and publishing it to my local drive.  Then I opened up Central Administration and uploaded the form to InfoPath Form Services and then activated it to my site collection.  I opened my site and created a new page and added the XMLFormView web part and specified the location of the form and published the page. 

The form worked great when returning small amounts of user information but had troubles handling large amounts of user information.  This brought me to the ideal of doing some sort of paging but when I went back to InfoPath I was unable to figure it out and I decided to postpone the research for another night but wanted to share the above ideal with everyone.  If anyone has any ideal on how to make the paging work I would love to hear about it.

Cheers,
Michael