Sharepoint list in InfoPath combo

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anders - 13 Feb 2006 12:30 GMT

Hi all,

I have a drop-down combo box in my InfoPath document that is filled with
data from a SharePoint list. The SharePoint list contains about 1100
elements. When I view the list in SharePoint it is devided in several pages
showing 100 elements per page. When I look at the data in my drop-down list
box in InfoPath only a part of the data is loaded. When I compare I notice
that only the first page from SharePoint is displayed in the drop-down.

Is there a way to handle this?

Thanks in advance
Anders

Reply to this Message

Anders - 13 Feb 2006 13:31 GMT

Hi me....again.

I found a not-the-most-attractive-but-working solution to this one.
In the default view in SharePoint under Item Limit it is possible to define
how many rows a batch should contain. I raised this value to fit all values.

> Hi all,
>
[quoted text clipped - 9 lines]
> Thanks in advance
> Anders

Reply to this Message

jmeyer - 14 Feb 2006 13:50 GMT

We have had the same issue using Reporting Services to report from
Sharepoint. I know this is an InfoPath newsgroup, but does anyone know
if there's a better way to solve this problem than to create a view
with the limit set high so as to show all records on one page?

josh

> Hi me....again.
>
[quoted text clipped - 15 lines]
> > Thanks in advance
> > Anders

Reply to this Message

jrhadley@kcm.org - 14 Feb 2006 20:30 GMT

one answer would be to move your list in to a backend database like
SQL.
then just set up your data connection to read from the database.
sharepoint is great for document storage but it has its limits.

Reply to this Message