The great Office Server smorgasbord is back and ready to tackle forms processing, possibly the most powerful use case for SharePoint and Office we’ve seen until now. To get through this one, we’ll need to start with a discussion of InfoPath 2007, then look at the basic Forms Services included with Office SharePoint Server and finally check out what else you get once you spring for the full-on form power of Forms Server 2007.

The Bottom Line InfoPath 2007 and Microsoft Office Forms Server 2007 Microsoft, microsoft.com Good  7.3 criteria score weight Ease-of-use 8 20% Features 8 20% Management 7 15% Scalability 7 20% Security 7 15% Value 6 10% Cost: InfoPath Client: $199 (est) Office Forms Server CAL: $54 (est) Office SharePoint Server 2007: $4,424 (est) Office Forms Server 2007: $4,424 (est) Platforms: Windows Server 2003, Windows XP, Vista Bottom Line: InfoPath 2007 and SharePoint 2007 Enterprise or Forms Server 2007 have enough combined power to truly revolutionize how your company handles forms. From content to display capabilities, the duo handles it all and adds security and business intelligence into the mix to boot About our Reviews and Scoring Methodology

InfoPath 2007
InfoPath begins as a good attempt to turn potential reams of paper into a more organized electronic format, but with the 2007 version you’ll be able to extend that concept quite a bit further. Instead of merely “electronifying” paper-based forms, InfoPath can turn those forms into living documents, information gatherers, and even business intelligence tools. You get access to those capabilities by tying InfoPath forms into existing back-end data resources, something InfoPath 2007 can do on its own with user toil, but is made much easier with the addition of SharePoint.

Working with InfoPath is a little like working with a visual Web page editor such as FrontPage. The InfoPath forms development environment presents options for look and feel, cell type, and back-end data sources, and users put them together into a usable form. That said, this can be much harder than it looks. Microsoft has tried to make it easier, first by including a few basic forms with InfoPath 2007, including meeting agendas and expense reports, and then offering the Microsoft Forms Template Library, which InfoPath users can access from Microsoft’s Web site.

Head to the library and you can download a wide variety of form templates, including invoices, purchase orders, project reports, time sheets and more. Downloading one of these templates and editing to suit your needs is undoubtedly easier than creating a form from scratch. InfoPath also supports converting forms from Word 2007 and Excel 2007 simply using Office 2007’s new XML-based file format.

Click for larger view.

Editing and saving a form in this manner is much like editing a Web page. Users can manipulate look and feel via the GUI and assign data sources that InfoPath automatically turns into a Forms Definition File (.xsf) and an underlying XML Schema (.xsd). The visual look is saved as an XSL Transformation file (.xsl) and the whole shebang combines to build that particular form template.

If we had a wish list for InfoPath 2007, the first item would be that Microsoft relax the enterprise orientation of InfoPath. Although you can bolt Forms Server 2007 onto a small or midsize business’ SharePoint infrastructure, InfoPath is part of only the Enterprise version of Microsoft Office. And there’s no special SMB version or pricing. That’s an oversight when you consider how many smaller businesses would like to make use of InfoPath as a homegrown business intelligence tool.

Make your forms smarter
Without devoting the rest of this article to a review of InfoPath, let’s cover some of the important features the application provides. First, forms designers can build in offline functionality as well as straight online features, so that form users can work with downloaded forms and return data at their convenience. Forms can also be distributed as an e-mail attachment or embedded in the e-mail itself -- that last one, however, requires the recipient to use Microsoft Outlook.

Security provides some neat capabilities as well, offering both digital signatures and domain-level trust assignments to your forms. Form builders can restrict the form to accept only specific kinds of data input, offer it domain-level trust or simply open the whole thing with full trust. Digital signatures allow users to assign signature certificates to not just a form, but individual cells in a form. This means that a form can require specific user signatures on its way through life, essentially creating a secure little workflow all its own.