Some fields that are promoted as columns do not appear in the columns list in a document library after you publish an InfoPath 2007 form template to a SharePoint Server site as the document library

View products that this article applies to.

SYMPTOMS

After you publish a Microsoft Office InfoPath 2007 form template to a Microsoft Office SharePoint Server site as a document library, some of the fields that are promoted as columns do not appear in the columns list in the library.

Back to the top

CAUSE

This issue occurs if the fields in the InfoPath 2007 form template are bound to the integer data type. When you specify a numeric data type in InfoPath 2007, you can select either Whole Number (integer) or Decimal (double). Microsoft Windows SharePoint Services only has a number data type that can accept these two types of values. However, an integer data type in InfoPath 2007 cannot accept a decimal value because no direct relationship exists to a SharePoint data type. Therefore, those fields cannot be displayed in the column list.

Back to the top

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

Back to the top

MORE INFORMATION

Steps to reproduce the issue

Create a new blank InfoPath form. To do this, follow these steps:
1. Start InfoPath 2007
2. On the File menu, click Design a Form.
3. Click Blank, and then click OK.
Add three text box controls to the form, and name the controls field1, field2, and field3.
Configure the controls. To do this, follow these steps:
1. Leave the data type of the field1 control as Text (string).
2. Double-click the field2 control, click Whole Number (Integer) in the Data type list, and then click OK.
3. Double-click the field3 control, click Decimal (double) in the Data type list, and then click OK.
Publish the InfoPath form to the server as a document library. To do this, follow these steps:
1. On the File menu, click Publish, and then save the file when you are prompted.
2. Click To a SharePoint Server with or without InfoPath Forms Services, and then click Next.
3. Type the location of the SharePoint Server 2007 or InfoPath Forms Service site, and then click Next.
4. Click Document Library, and then click Next.
5. Click Create a new document library, and then click Next.
6. In the Name box, type ColumnTest, and then click Next.
7. Click Add, click field1, and then click OK.
8. Repeat step 3g for the field2 and field3 controls.
9. Click Next, click Publish, and then click Close.
Open the ColumnTest form library, and then click Form Library Settings in the Settings list.

Under Columns, only Field 1 and Field 3 appear.