InfoPath 2010

Re: How can I display multiple columns from a SharePoint List

jaydhumal — Thu, 15 Jul 2010 20:18:22 GMT

Hello let me explain it step by step

1. create a text box control which will be bound to job title

2. create a repeating table section which would be bounded to the other fields you wish to display

say SOP1 , SOP2 , SOP3 etc

3. create a rule for each SOPs and add a filter to select them only when the secondary title matches to the database title

Re: How can I display multiple columns from a SharePoint List

ErnestoM — Fri, 09 Jul 2010 12:43:06 GMT

One idea would be to filter using Owssvr. Here are some articles that may help:

http://vspug.com/dwise/2008/01/10/accessing-sharepoint-list-data-as-xml/

http://geekswithblogs.net/PsudoKnowledgeBase/archive/2010/02/01/using-owssvr.dll-to-filter-sharepoint-data-on-the-server-side.aspx

http://www.bizsupportonline.net/blog/2009/07/pre-filter-large-sharepoint-list-infopath-wss-owssvr-dll/

Of course, one option is to do the filtering in InfoPath itself, but if your source data is large then this will slow down the form considerably. We have previous threads on this, such as this one:

http://www.infopathdev.com/forums/p/9329/33038.aspx

Good luck!

How can I display multiple columns from a SharePoint List

seanthare — Thu, 08 Jul 2010 20:55:07 GMT

I am trying to display multiple columns from a sharepoint list based on a filter of another field in the InfoPath form.

Two questions:

What control should be used to display the column in the form?
How to display each column in its own control?

Sample data:

Job Titles	Department	SOP1	SOP2	SOP3
Batch Maker	Batching	100.00	101.00	703
Batching Auditor	Quality and Scientific Affairs	100.00	101.00	807
Batching Lead	Batching	100.00	101.00	703
Batching Planner	Batching	100.00	101.00	2300
Batching Mechanic	Batching	100.00	101.00	703
Benefits Coordinator	Human Resources	100.00	100.01	2500

The filter is on the Job Title and I want to display the SOPs.

Thanks,

Sean