Cascading Dropdowns in Browser Forms

re: Cascading Dropdowns in Browser Forms

Nemo — Thu, 19 Jul 2012 15:48:50 GMT

Hi Scott,

Nice article! Thanks for posting it! :)

re: Cascading Dropdowns in Browser Forms

vijaidev — Thu, 24 May 2012 12:53:11 GMT

great article. it works in default website generated from VS2005/08. but not in under (IIS)localhost. it throws error when clicking invoke btn for getcustomers as (The user is not associated with a trusted sql server connection.)

i am having sql server seperately (but in same domain)and calling name of that server in data source..

pls help me..as iam in the halfway

re: Cascading Dropdowns in Browser Forms

InfopathDude — Wed, 08 Dec 2010 18:30:43 GMT

I think you need to correct this post as it is misleading. Because you can execute filters on web based infopath forms in Sharepoint 2010. As demonstrated here:

sharepointsolutions.com/.../sharepoint-2010-tutorial-video-drop-down-filters

re: Cascading Dropdowns in Browser Forms

Becky — Sat, 27 Nov 2010 18:18:10 GMT

anyone tell me what version of VB to use with SP 2007 server 3.0 and form services 07?

re: Cascading Dropdowns in Browser Forms

Lucas — Wed, 03 Nov 2010 11:17:24 GMT

Is it possible to have rules or seperate xml's without creating a webservice to make this cascading work for browser enabled forms?

I am able to set the second dropdown value based on the first, BUT it only takes the first value of the "new" xml list??

re: Cascading Dropdowns in Browser Forms

infopath1 — Fri, 17 Jul 2009 00:51:22 GMT

Hi pbakker_67,

I don't believe the "express" edition will provide the functionality you will need. I believe you will need a "Professional" level or greater to get the features for this type of functionality.

Scott

re: Cascading Dropdowns in Browser Forms

pbakker_67 — Tue, 14 Jul 2009 18:10:19 GMT

Hi,

Is there anywhere a walkthrough for this procedure? I'm quite a newbe on this, an on step 2 visual web developpers 2008 express already giving the error: does not support opening Sharepoint Web sites.

re: Cascading Dropdowns in Browser Forms

infopath1 — Fri, 26 Jun 2009 20:28:46 GMT

Thanks Elliott!

re: Cascading Dropdowns in Browser Forms

Elliott W — Fri, 26 Jun 2009 01:06:31 GMT

Excellent article! Thanks so much. I needed to populate cascading dropdowns from SharePoint lists in the main site collection, so I just replaced the web service file with this:

<code>

<%@ WebService Language="C#" Class="ListAccess.ListAccessService" %>

<%@ Assembly Name="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"%>

using System;

using System.Web;

using System.Web.Services;

using System.Web.Services.Protocols;

using Microsoft.SharePoint;

using System.Xml;

namespace ListAccess

{

[WebService(Namespace = "http://localhost/ListAccess", Description = "Provides access to SharePoint Lists")]

class ListAccessService : WebService

{

[WebMethod(Description = @"Gets filtered items from the specified list.

Be sure to use the internal name for the filterField.")]

public XmlDocument GetListItems(string listName, string filterField, string filterValue)

{

XmlDocument returnDoc = new XmlDocument();

using (SPSite site = SPContext.Current.Site)

{

using (SPWeb web = site.RootWeb)

{

SPList list = web.Lists[listName];

string queryText = String.Format(@"<Where>

<Eq>

</Eq>

</Where>", filterField, filterValue);

SPQuery query = new SPQuery();

query.Query = queryText;

SPListItemCollection items = list.GetItems(query);

returnDoc.LoadXml(items.Xml);

}

return returnDoc;

}

</code>

Implementing Cascading Dropdowns in Forms Server

David Airapetyan — Wed, 11 Feb 2009 00:06:29 GMT

The InfoPath Team Blog has a great article on how to implement cascading dropdowns in InfoPath Forms