Wednesday, February 13, 2008

Showing a Calculated Column in Infopath 2007

Here is a small tip about how to display a Sharepoint Lists' calculated column in infopath 2007.1. Create your lists in Sharepoint with a calculated column (Field1&Field2)2. In Infopath 2007, create a data connection use XML file use the following (http://servername/_vti_bin/owssvr.dll?cmd=Display&List={GUID of the Lists}&XMLDATA=TRUE3. Choose this data connection in your drop down lists, and choose your field.

4 comments:

Pierre Andre Joubert said...

This does not seem to work, infopath claims the address is invalid????

Akthar said...

Hi ,
What version of Infopath are you running, also have you published the form on your sharepoint server?

Pierre Andre Joubert said...

hi akthar, seems to be a my fault. I did not include the subsites in the path.

It is now working, the only thing is that it is not showing my columns, just the xml structure, no columns are listed, have I done something wrong or not done something?

Thanks
Pierre

Akthar said...

Hi,
Check your dropdown properties, may be you have not chosen the field in the data box