InfoPath Dev

I am trying to figure out how to read data from an xml datasource.  I have the xml as a datasource for my form.  I am trying to write some code that will read that code, but I am having trouble trying to figure out how to call it.  I believe xmltextreader is the appropriate thing to use, but not sure how to call the datasource as the file to read.

 

Dim reader As XmlTextReader = New XmlTextReader((Me.DataSources("Roster")))

That doesnt work.  Can anyone help me out.  Thanks

If you call CreateNavigator() on a data source, you can get an XPathNavigator for it, but you still can't pass that to the XmlTextReader constructor.  What is it that you are trying to accomplish?

Trying to do a cascading listbox on a browser enabled form.  Everything i found on a google search didnt work, so i figured id try to code it.  I have the data the way I want it in an xml file.  It is 5 levels im trying to cascade.  I figured if i could read the xml i could find the data i want and put it in the list.

 

Any ideas?

The XPathNavigator should be all you need to traverse the XML data source.  There shouldn't be any need to load it into an XmlTextReader, so I suggest getting acquainted with the XPathNavigator class.

Ok, so i got into the file another way.

Dim reader As XmlTextReader = New XmlTextReader("https://....../Roster.xml")

reader.Read()

when i try to execute the read() i get the following error:

An exception of type 'System.Security.SecurityException' occurred in System.Xml.dll but was not handled in user code

Additional information: Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

 

How to i resolve this

Can I ask why you insist on using an XmlTextReader?

I dont have to.

 I am new to infopath and dont know the best ways to do things.  Any help you can give me would be appreciated.

 Everything I try fails or there is an exception.  Who would have though a cascading listbox would be so hard.  Stupid infopath and no filtering in browser enabled forms

Honestly, you are right - it is hard.

That said, first, I'm wondering if any of your listboxes that need to cascade are inside a repeating section? Because that adds a whole new level of hardship to the issue.

There are two approaches to this issue:

1. Filter the data before it gets to your form (only returning the items you want)
2. Filter the data after it gets to your form (removing the unneeded items from the data source used by the control)

My opinion is that option 1 is easier in a lot of ways. You can use the owssvr.dll in SharePoint and either add a filter via code (and the code is not too complex here) or you can use qRules (I saw from another post that you had installed qRules but were having trouble running the injector - hopefully we can help you with that if you choose this route). One of the benefits of qRules would be that you wouldn't have to write any code at all. You can also build or buy a web service that allows you to query for only the data we need (we sell a great web service here.)

For option 2, you are looking at a greater level of complexity. You probably need to copy your secondary data to yet another 2DS so that you can remove the items you don't need, and then update with the items you do need if the user changes the value in one of the earlier drop downs. Or, you can requery for all the data each time, but that seems a little resource intensive to me - may as well query once, copy elsewhere and re-populate as needed from your now cached data.

The form does not need to be repearting.  Basically what i need is this.  textbox one has the highest level manager, that is already set.  Listbox one has the next level of managers that report to the level 1 guy.  listbox two will have the managers reporting to the manager that was selected in level 2.  continue this until the last list box.  It is basically a treeview sort of.  Below is what my XML looks like.  I hope it makes sense.  Sorry it is so long, didnt know how to put the code box in the post or attach file.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

                <Manager_Lvl1>

                                <manager id="1">Persons Name</manager>

                </Manager_Lvl1>

                <Manager_Lvl2>

                                <manager2 manager="1" id="1”>Persons Name</manager2>

                                <manager2 manager="1" id="2”>Persons Name</manager2>

                                <manager2 manager="1" id="3”>Persons Name</manager2>

                                <manager2 manager="1" id="4”>Persons Name</manager2>

                                <manager2 manager="1" id="5”>Persons Name</manager2>

                                <manager2 manager="1" id="6”>Persons Name</manager2>

                                <manager2 manager="1" id="7”>Persons Name</manager2>

                                <manager2 manager="1" id="8”>Persons Name</manager2>

                                <manager2 manager="1" id="9”>Persons Name</manager2>

                                <manager2 manager="1" id="10”>Persons Name</manager2>

                </Manager_Lvl2>

                <Manager_Lvl3>

                                <manager3 manager2="1" id="1”>Persons Name</manager3>

                                <manager3 manager2="1" id="2”>Persons Name</manager3>

                                <manager3 manager2="1" id="3”>Persons Name</manager3>

                                <manager3 manager2="1" id="4”>Persons Name</manager3>

                                <manager3 manager2="1" id="5”>Persons Name</manager3>

                                <manager3 manager2="1" id="6”>Persons Name</manager3>

                                <manager3 manager2="1" id="7”>Persons Name</manager3>

                                <manager3 manager2="1" id="8”>Persons Name</manager3>

                                <manager3 manager2="1" id="9”>Persons Name</manager3>

                                <manager3 manager2="1" id="10”>Persons Name</manager3>

                                <manager3 manager2="1" id="11”>Persons Name</manager3>

                                <manager3 manager2="1" id="12”>Persons Name</manager3>

                                <manager3 manager2="3" id="13”>Persons Name</manager3>

                                <manager3 manager2="3" id="14”>Persons Name</manager3>

                                <manager3 manager2="3" id="15”>Persons Name</manager3>

                                <manager3 manager2="3" id="16”>Persons Name</manager3>

                                <manager3 manager2="3" id="17”>Persons Name</manager3>

                                <manager3 manager2="3" id="18”>Persons Name</manager3>

                                <manager3 manager2="3" id="19”>Persons Name</manager3>

                                <manager3 manager2="3" id="20”>Persons Name</manager3>

                                <manager3 manager2="3" id="21”>Persons Name</manager3>

                                <manager3 manager2="3" id="22”>Persons Name</manager3>

                                <manager3 manager2="4" id="23”>Persons Name</manager3>

                                <manager3 manager2="4" id="24”>Persons Name</manager3>

                                <manager3 manager2="4" id="25”>Persons Name</manager3>

                                <manager3 manager2="4" id="26”>Persons Name</manager3>

                                <manager3 manager2="4" id="27”>Persons Name</manager3>

                                <manager3 manager2="4" id="28”>Persons Name</manager3>

                                <manager3 manager2="4" id="29”>Persons Name</manager3>

                                <manager3 manager2="5" id="30”>Persons Name</manager3>

                                <manager3 manager2="5" id="31”>Persons Name</manager3>

                                <manager3 manager2="5" id="32”>Persons Name</manager3>

                                <manager3 manager2="5" id="33”>Persons Name</manager3>

                                <manager3 manager2="5" id="34”>Persons Name</manager3>

                                <manager3 manager2="6" id="35”>Persons Name</manager3>

                                <manager3 manager2="6" id="36”>Persons Name</manager3>

                                <manager3 manager2="6" id="37”>Persons Name</manager3>

                                <manager3 manager2="6" id="38”>Persons Name</manager3>

                                <manager3 manager2="6" id="39”>Persons Name</manager3>

                                <manager3 manager2="6" id="40”>Persons Name</manager3>

                                <manager3 manager2="6" id="41”>Persons Name</manager3>

                                <manager3 manager2="6" id="42”>Persons Name</manager3>

                                <manager3 manager2="6" id="43”>Persons Name</manager3>

                                <manager3 manager2="6" id="44”>Persons Name</manager3>

                                <manager3 manager2="6" id="45”>Persons Name</manager3>

                                <manager3 manager2="6" id="46”>Persons Name</manager3>

                                <manager3 manager2="6" id="47”>Persons Name</manager3>

                                <manager3 manager2="6" id="48”>Persons Name</manager3>

                                <manager3 manager2="6" id="49”>Persons Name</manager3>

                                <manager3 manager2="6" id="50”>Persons Name</manager3>

                                <manager3 manager2="6" id="51”>Persons Name</manager3>

                                <manager3 manager2="6" id="52”>Persons Name</manager3>

                                <manager3 manager2="6" id="53”>Persons Name</manager3>

                                <manager3 manager2="6" id="54”>Persons Name</manager3>

                                <manager3 manager2="6" id="55”>Persons Name</manager3>

                                <manager3 manager2="6" id="56”>Persons Name</manager3>

                                <manager3 manager2="6" id="57”>Persons Name</manager3>

                                <manager3 manager2="6" id="58”>Persons Name</manager3>

                                <manager3 manager2="6" id="59”>Persons Name</manager3>

                                <manager3 manager2="7" id="60”>Persons Name</manager3>

                                <manager3 manager2="7" id="61”>Persons Name</manager3>

                                <manager3 manager2="7" id="62”>Persons Name</manager3>

                                <manager3 manager2="7" id="63”>Persons Name</manager3>

                                <manager3 manager2="7" id="64”>Persons Name</manager3>

                                <manager3 manager2="7" id="65”>Persons Name</manager3>

                                <manager3 manager2="7" id="66”>Persons Name</manager3>

                                <manager3 manager2="8" id="67”>Persons Name</manager3>

                                <manager3 manager2="8" id="68”>Persons Name</manager3>

                                <manager3 manager2="8" id="69”>Persons Name</manager3>

                                <manager3 manager2="8" id="70”>Persons Name</manager3>

                                <manager3 manager2="9" id="71”>Persons Name</manager3>

                                <manager3 manager2="9" id="72”>Persons Name</manager3>

                                <manager3 manager2="9" id="73”>Persons Name</manager3>

                                <manager3 manager2="9" id="74”>Persons Name</manager3>

                                <manager3 manager2="9" id="75”>Persons Name</manager3>

                                <manager3 manager2="10" id="76”>Persons Name</manager3>

                                <manager3 manager2="10" id="77”>Persons Name</manager3>

                                <manager3 manager2="10" id="78”>Persons Name</manager3>

                                <manager3 manager2="10" id="79”>Persons Name</manager3>

                </Manager_Lvl3>

                <Manager_Lvl4>

                                <manager4 manager3="2" id="1”>Persons Name</manager4>

                                <manager4 manager3="2" id="2”>Persons Name</manager4>

                                <manager4 manager3="2" id="3”>Persons Name</manager4>

                                <manager4 manager3="2" id="4”>Persons Name</manager4>

                                <manager4 manager3="2" id="5”>Persons Name</manager4>

                                <manager4 manager3="2" id="6”>Persons Name</manager4>

                                <manager4 manager3="2" id="7”>Persons Name</manager4>

                                <manager4 manager3="2" id="8”>Persons Name</manager4>

                                <manager4 manager3="2" id="9”>Persons Name</manager4>

                                <manager4 manager3="2" id="10”>Persons Name</manager4>

                                <manager4 manager3="2" id="11”>Persons Name</manager4>

                                <manager4 manager3="2" id="12”>Persons Name</manager4>

                                <manager4 manager3="2" id="13”>Persons Name</manager4>

                                <manager4 manager3="2" id="14”>Persons Name</manager4>

                                <manager4 manager3="6" id="15”>Persons Name</manager4>

                                <manager4 manager3="6" id="16”>Persons Name</manager4>

                                <manager4 manager3="6" id="17”>Persons Name</manager4>

                                <manager4 manager3="6" id="18”>Persons Name</manager4>

                                <manager4 manager3="6" id="19”>Persons Name</manager4>

                                <manager4 manager3="6" id="20”>Persons Name</manager4>

                                <manager4 manager3="6" id="21”>Persons Name</manager4>

                                <manager4 manager3="6" id="22”>Persons Name</manager4>

                                <manager4 manager3="6" id="23”>Persons Name</manager4>

                                <manager4 manager3="6" id="24”>Persons Name</manager4>

                                <manager4 manager3="6" id="25”>Persons Name</manager4>

                                <manager4 manager3="6" id="26”>Persons Name</manager4>

                                <manager4 manager3="7" id="27”>Persons Name</manager4>

                                <manager4 manager3="7" id="28”>Persons Name</manager4>

                                <manager4 manager3="7" id="29”>Persons Name</manager4>

                                <manager4 manager3="7" id="30”>Persons Name</manager4>

                                <manager4 manager3="7" id="31”>Persons Name</manager4>

                                <manager4 manager3="7" id="32”>Persons Name</manager4>

                                <manager4 manager3="7" id="33”>Persons Name</manager4>

                                <manager4 manager3="7" id="34”>Persons Name</manager4>

                                <manager4 manager3="7" id="35”>Persons Name</manager4>

                                <manager4 manager3="7" id="36”>Persons Name</manager4>

                                <manager4 manager3="7" id="37”>Persons Name</manager4>

                                <manager4 manager3="7" id="38”>Persons Name</manager4>

                                <manager4 manager3="7" id="39”>Persons Name</manager4>

                                <manager4 manager3="7" id="40”>Persons Name</manager4>

                                <manager4 manager3="7" id="41”>Persons Name</manager4>

                                <manager4 manager3="7" id="42”>Persons Name</manager4>

                                <manager4 manager3="8" id="43”>Persons Name</manager4>

                                <manager4 manager3="8" id="44”>Persons Name</manager4>

                                <manager4 manager3="8" id="45”>Persons Name</manager4>

                                <manager4 manager3="8" id="46”>Persons Name</manager4>

                                <manager4 manager3="9" id="47”>Persons Name</manager4>

                                <manager4 manager3="9" id="48”>Persons Name</manager4>

                                <manager4 manager3="9" id="49”>Persons Name</manager4>

                                <manager4 manager3="9" id="50”>Persons Name</manager4>

                                <manager4 manager3="9" id="51”>Persons Name</manager4>

                                <manager4 manager3="9" id="52”>Persons Name</manager4>

                                <manager4 manager3="9" id="53”>Persons Name</manager4>

                                <manager4 manager3="9" id="54”>Persons Name</manager4>

                                <manager4 manager3="9" id="55”>Persons Name</manager4>

                                <manager4 manager3="9" id="56”>Persons Name</manager4>

                                <manager4 manager3="9" id="57”>Persons Name</manager4>

                                <manager4 manager3="9" id="58”>Persons Name</manager4>

                                <manager4 manager3="9" id="59”>Persons Name</manager4>

                                <manager4 manager3="9" id="60”>Persons Name</manager4>

                                <manager4 manager3="9" id="61”>Persons Name</manager4>

                                <manager4 manager3="9" id="62”>Persons Name</manager4>

                                <manager4 manager3="10" id="63”>Persons Name</manager4>

                                <manager4 manager3="11" id="64”>Persons Name</manager4>

                                <manager4 manager3="11" id="65”>Persons Name</manager4>

                                <manager4 manager3="11" id="66”>Persons Name</manager4>

                                <manager4 manager3="11" id="67”>Persons Name</manager4>

                                <manager4 manager3="11" id="68”>Persons Name</manager4>

                                <manager4 manager3="11" id="69”>Persons Name</manager4>

                                <manager4 manager3="11" id="70”>Persons Name</manager4>

                                <manager4 manager3="11" id="71”>Persons Name</manager4>

                                <manager4 manager3="11" id="72”>Persons Name</manager4>

                                <manager4 manager3="11" id="73”>Persons Name</manager4>

                                <manager4 manager3="11" id="74”>Persons Name</manager4>

                                <manager4 manager3="11" id="75”>Persons Name</manager4>

                                <manager4 manager3="19" id="76”>Persons Name</manager4>

                                <manager4 manager3="19" id="77”>Persons Name</manager4>

                                <manager4 manager3="19" id="78”>Persons Name</manager4>

                                <manager4 manager3="19" id="79”>Persons Name</manager4>

                                <manager4 manager3="19" id="80”>Persons Name</manager4>

                                <manager4 manager3="19" id="81”>Persons Name</manager4>

                                <manager4 manager3="19" id="82”>Persons Name</manager4>

                                <manager4 manager3="19" id="83”>Persons Name</manager4>

                                <manager4 manager3="19" id="84”>Persons Name</manager4>

                                <manager4 manager3="19" id="85”>Persons Name</manager4>

                                <manager4 manager3="19" id="86”>Persons Name</manager4>

                                <manager4 manager3="19" id="87”>Persons Name</manager4>

                                <manager4 manager3="19" id="88”>Persons Name</manager4>

                                <manager4 manager3="19" id="89”>Persons Name</manager4>

                                <manager4 manager3="19" id="90”>Persons Name</manager4>

                                <manager4 manager3="20" id="91”>Persons Name</manager4>

                                <manager4 manager3="20" id="92”>Persons Name</manager4>

                                <manager4 manager3="20" id="93”>Persons Name</manager4>

                                <manager4 manager3="20" id="94”>Persons Name</manager4>

                                <manager4 manager3="20" id="95”>Persons Name</manager4>

                                <manager4 manager3="20" id="96”>Persons Name</manager4>

                                <manager4 manager3="20" id="97”>Persons Name</manager4>

                                <manager4 manager3="20" id="98”>Persons Name</manager4>

                                <manager4 manager3="20" id="99”>Persons Name</manager4>

                                <manager4 manager3="20" id="100”>Persons Name</manager4>

                                <manager4 manager3="20" id="101”>Persons Name</manager4>

                                <manager4 manager3="23" id="102”>Persons Name</manager4>

                                <manager4 manager3="23" id="103”>Persons Name</manager4>

                                <manager4 manager3="23" id="104”>Persons Name</manager4>

                                <manager4 manager3="23" id="105”>Persons Name</manager4>

                                <manager4 manager3="23" id="106”>Persons Name</manager4>

                                <manager4 manager3="23" id="107”>Persons Name</manager4>

                                <manager4 manager3="23" id="108”>Persons Name</manager4>

                                <manager4 manager3="23" id="109”>Persons Name</manager4>

                                <manager4 manager3="23" id="110”>Persons Name</manager4>

                                <manager4 manager3="23" id="111”>Persons Name</manager4>

                                <manager4 manager3="23" id="112”>Persons Name</manager4>

                                <manager4 manager3="23" id="113”>Persons Name</manager4>

                                <manager4 manager3="23" id="114”>Persons Name</manager4>

                                <manager4 manager3="23" id="115”>Persons Name</manager4>

                                <manager4 manager3="24" id="116”>Persons Name</manager4>

                                <manager4 manager3="24" id="117”>Persons Name</manager4>

                                <manager4 manager3="24" id="118”>Persons Name</manager4>

                                <manager4 manager3="24" id="119”>Persons Name</manager4>

                                <manager4 manager3="24" id="120”>Persons Name</manager4>

                                <manager4 manager3="24" id="121”>Persons Name</manager4>

                                <manager4 manager3="24" id="122”>Persons Name</manager4>

                                <manager4 manager3="26" id="123”>Persons Name</manager4>

                                <manager4 manager3="26" id="124”>Persons Name</manager4>

                                <manager4 manager3="26" id="125”>Persons Name</manager4>

                                <manager4 manager3="26" id="126”>Persons Name</manager4>

                                <manager4 manager3="26" id="127”>Persons Name</manager4>

                                <manager4 manager3="26" id="128”>Persons Name</manager4>

                                <manager4 manager3="26" id="129”>Persons Name</manager4>

                                <manager4 manager3="26" id="130”>Persons Name</manager4>

                                <manager4 manager3="26" id="131”>Persons Name</manager4>

                                <manager4 manager3="26" id="132”>Persons Name</manager4>

                                <manager4 manager3="28" id="133”>Persons Name</manager4>

                                <manager4 manager3="35" id="134”>Persons Name</manager4>

                                <manager4 manager3="35" id="135”>Persons Name</manager4>

                                <manager4 manager3="35" id="136”>Persons Name</manager4>

                                <manager4 manager3="35" id="137”>Persons Name</manager4>

                                <manager4 manager3="35" id="138”>Persons Name</manager4>

                                <manager4 manager3="35" id="139”>Persons Name</manager4>

                                <manager4 manager3="35" id="140”>Persons Name</manager4>

                                <manager4 manager3="35" id="141”>Persons Name</manager4>

                                <manager4 manager3="35" id="142”>Persons Name</manager4>

                                <manager4 manager3="35" id="143”>Persons Name</manager4>

                                <manager4 manager3="43" id="144”>Persons Name</manager4>

                                <manager4 manager3="43" id="145”>Persons Name</manager4>

                                <manager4 manager3="43" id="146”>Persons Name</manager4>

                                <manager4 manager3="43" id="147”>Persons Name</manager4>

                                <manager4 manager3="43" id="148”>Persons Name</manager4>

                                <manager4 manager3="43" id="149”>Persons Name</manager4>

                                <manager4 manager3="43" id="150”>Persons Name</manager4>

                                <manager4 manager3="43" id="151”>Persons Name</manager4>

                                <manager4 manager3="43" id="152”>Persons Name</manager4>

                                <manager4 manager3="43" id="153”>Persons Name</manager4>

                                <manager4 manager3="43" id="154”>Persons Name</manager4>

                                <manager4 manager3="43" id="155”>Persons Name</manager4>

                                <manager4 manager3="43" id="156”>Persons Name</manager4>

                                <manager4 manager3="43" id="157”>Persons Name</manager4>

                                <manager4 manager3="43" id="158”>Persons Name</manager4>

                                <manager4 manager3="43" id="159”>Persons Name</manager4>

                                <manager4 manager3="43" id="160”>Persons Name</manager4>

                                <manager4 manager3="46" id="161”>Persons Name</manager4>

                                <manager4 manager3="46" id="162”>Persons Name</manager4>

                                <manager4 manager3="46" id="163”>Persons Name</manager4>

                                <manager4 manager3="46" id="164”>Persons Name</manager4>

                                <manager4 manager3="46" id="165”>Persons Name</manager4>

                                <manager4 manager3="46" id="166”>Persons Name</manager4>

                                <manager4 manager3="46" id="167”>Persons Name</manager4>

                                <manager4 manager3="47" id="168”>Persons Name</manager4>

                                <manager4 manager3="47" id="169”>Persons Name</manager4>

                                <manager4 manager3="52" id="170”>Persons Name</manager4>

                                <manager4 manager3="52" id="171”>Persons Name</manager4>

                                <manager4 manager3="52" id="172”>Persons Name</manager4>

                                <manager4 manager3="52" id="173”>Persons Name</manager4>

                                <manager4 manager3="52" id="174”>Persons Name</manager4>

                                <manager4 manager3="52" id="175”>Persons Name</manager4>

                                <manager4 manager3="52" id="176”>Persons Name</manager4>

                                <manager4 manager3="53" id="177”>Persons Name</manager4>

                                <manager4 manager3="53" id="178”>Persons Name</manager4>

                                <manager4 manager3="53" id="179”>Persons Name</manager4>

                                <manager4 manager3="53" id="180”>Persons Name</manager4>

                                <manager4 manager3="53" id="181”>Persons Name</manager4>

                                <manager4 manager3="53" id="182”>Persons Name</manager4>

                                <manager4 manager3="53" id="183”>Persons Name</manager4>

                                <manager4 manager3="53" id="184”>Persons Name</manager4>

                                <manager4 manager3="53" id="185”>Persons Name</manager4>

                                <manager4 manager3="53" id="186”>Persons Name</manager4>

                                <manager4 manager3="53" id="187”>Persons Name</manager4>

                                <manager4 manager3="53" id="188”>Persons Name</manager4>

                                <manager4 manager3="53" id="189”>Persons Name</manager4>

                                <manager4 manager3="53" id="190”>Persons Name</manager4>

                                <manager4 manager3="53" id="191”>Persons Name</manager4>

                                <manager4 manager3="54" id="192”>Persons Name</manager4>

                                <manager4 manager3="54" id="193”>Persons Name</manager4>

                                <manager4 manager3="54" id="194”>Persons Name</manager4>

                                <manager4 manager3="54" id="195”>Persons Name</manager4>

                                <manager4 manager3="54" id="196”>Persons Name</manager4>

                                <manager4 manager3="54" id="197”>Persons Name</manager4>

                                <manager4 manager3="54" id="198”>Persons Name</manager4>

                                <manager4 manager3="54" id="199”>Persons Name</manager4>

                                <manager4 manager3="54" id="200”>Persons Name</manager4>

                                <manager4 manager3="54" id="201”>Persons Name</manager4>

                                <manager4 manager3="54" id="202”>Persons Name</manager4>

                                <manager4 manager3="54" id="203”>Persons Name</manager4>

                                <manager4 manager3="54" id="204”>Persons Name</manager4>

                                <manager4 manager3="54" id="205”>Persons Name</manager4>

                                <manager4 manager3="54" id="206”>Persons Name</manager4>

                                <manager4 manager3="54" id="207”>Persons Name</manager4>

                                <manager4 manager3="54" id="208”>Persons Name</manager4>

                                <manager4 manager3="54" id="209”>Persons Name</manager4>

                                <manager4 manager3="54" id="210”>Persons Name</manager4>

                                <manager4 manager3="54" id="211”>Persons Name</manager4>

                                <manager4 manager3="54" id="212”>Persons Name</manager4>

                                <manager4 manager3="54" id="213”>Persons Name</manager4>

                                <manager4 manager3="54" id="214”>Persons Name</manager4>

                                <manager4 manager3="54" id="215”>Persons Name</manager4>

                                <manager4 manager3="54" id="216”>Persons Name</manager4>

                                <manager4 manager3="60" id="217”>Persons Name</manager4>

                                <manager4 manager3="60" id="218”>Persons Name</manager4>

                                <manager4 manager3="60" id="219”>Persons Name</manager4>

                                <manager4 manager3="60" id="220”>Persons Name</manager4>

                                <manager4 manager3="60" id="221”>Persons Name</manager4>

                                <manager4 manager3="60" id="222”>Persons Name</manager4>

                                <manager4 manager3="60" id="223”>Persons Name</manager4>

                                <manager4 manager3="60" id="224”>Persons Name</manager4>

                                <manager4 manager3="60" id="225”>Persons Name</manager4>

                                <manager4 manager3="60" id="226”>Persons Name</manager4>

                                <manager4 manager3="61" id="227”>Persons Name</manager4>

                                <manager4 manager3="61" id="228”>Persons Name</manager4>

                                <manager4 manager3="61" id="229”>Persons Name</manager4>

                                <manager4 manager3="61" id="230”>Persons Name</manager4>

                                <manager4 manager3="61" id="231”>Persons Name</manager4>

                                <manager4 manager3="61" id="232”>Persons Name</manager4>

                                <manager4 manager3="61" id="233”>Persons Name</manager4>

                                <manager4 manager3="61" id="234”>Persons Name</manager4>

                                <manager4 manager3="61" id="235”>Persons Name</manager4>

                                <manager4 manager3="61" id="236”>Persons Name</manager4>

                                <manager4 manager3="61" id="237”>Persons Name</manager4>

                                <manager4 manager3="61" id="238”>Persons Name</manager4>

                                <manager4 manager3="61" id="239”>Persons Name</manager4>

                                <manager4 manager3="62" id="240”>Persons Name</manager4>

                                <manager4 manager3="62" id="241”>Persons Name</manager4>

                                <manager4 manager3="62" id="242”>Persons Name</manager4>

                                <manager4 manager3="62" id="243”>Persons Name</manager4>

                                <manager4 manager3="62" id="244”>Persons Name</manager4>

                                <manager4 manager3="62" id="245”>Persons Name</manager4>

                                <manager4 manager3="62" id="246”>Persons Name</manager4>

                                <manager4 manager3="62" id="247”>Persons Name</manager4>

                                <manager4 manager3="62" id="248”>Persons Name</manager4>

                                <manager4 manager3="62" id="249”>Persons Name</manager4>

                                <manager4 manager3="62" id="250”>Persons Name</manager4>

                                <manager4 manager3="62" id="251”>Persons Name</manager4>

                                <manager4 manager3="63" id="252”>Persons Name</manager4>

                                <manager4 manager3="63" id="253”>Persons Name</manager4>

                                <manager4 manager3="63" id="254”>Persons Name</manager4>

                                <manager4 manager3="63" id="255”>Persons Name</manager4>

                                <manager4 manager3="63" id="256”>Persons Name</manager4>

                                <manager4 manager3="63" id="257”>Persons Name</manager4>

                                <manager4 manager3="63" id="258”>Persons Name</manager4>

                                <manager4 manager3="63" id="259”>Persons Name</manager4>

                                <manager4 manager3="63" id="260”>Persons Name</manager4>

                                <manager4 manager3="63" id="261”>Persons Name</manager4>

                                <manager4 manager3="63" id="262”>Persons Name</manager4>

                                <manager4 manager3="63" id="263”>Persons Name</manager4>

                                <manager4 manager3="63" id="264”>Persons Name</manager4>

                                <manager4 manager3="63" id="265”>Persons Name</manager4>

                                <manager4 manager3="64" id="266”>Persons Name</manager4>

                                <manager4 manager3="64" id="267”>Persons Name</manager4>

                                <manager4 manager3="64" id="268”>Persons Name</manager4>

                                <manager4 manager3="64" id="269”>Persons Name</manager4>

                                <manager4 manager3="64" id="270”>Persons Name</manager4>

                                <manager4 manager3="64" id="271”>Persons Name</manager4>

                                <manager4 manager3="64" id="272”>Persons Name</manager4>

                                <manager4 manager3="64" id="273”>Persons Name</manager4>

                                <manager4 manager3="64" id="274”>Persons Name</manager4>

                                <manager4 manager3="64" id="275”>Persons Name</manager4>

                                <manager4 manager3="64" id="276”>Persons Name</manager4>

                                <manager4 manager3="65" id="277”>Persons Name</manager4>

                                <manager4 manager3="65" id="278”>Persons Name</manager4>

                                <manager4 manager3="65" id="279”>Persons Name</manager4>

                                <manager4 manager3="65" id="280”>Persons Name</manager4>

                                <manager4 manager3="65" id="281”>Persons Name</manager4>

                                <manager4 manager3="65" id="282”>Persons Name</manager4>

                                <manager4 manager3="65" id="283”>Persons Name</manager4>

                                <manager4 manager3="65" id="284”>Persons Name</manager4>

                                <manager4 manager3="66" id="285”>Persons Name</manager4>

                                <manager4 manager3="66" id="286”>Persons Name</manager4>

                                <manager4 manager3="66" id="287”>Persons Name</manager4>

                                <manager4 manager3="66" id="288”>Persons Name</manager4>

                                <manager4 manager3="66" id="289”>Persons Name</manager4>

                                <manager4 manager3="66" id="290”>Persons Name</manager4>

                                <manager4 manager3="66" id="291”>Persons Name</manager4>

                                <manager4 manager3="66" id="292”>Persons Name</manager4>

                                <manager4 manager3="66" id="293”>Persons Name</manager4>

                                <manager4 manager3="67" id="294”>Persons Name</manager4>

                                <manager4 manager3="67" id="295”>Persons Name</manager4>

                                <manager4 manager3="67" id="296”>Persons Name</manager4>

                                <manager4 manager3="67" id="297”>Persons Name</manager4>

                                <manager4 manager3="67" id="298”>Persons Name</manager4>

                                <manager4 manager3="67" id="299”>Persons Name</manager4>

                                <manager4 manager3="67" id="300”>Persons Name</manager4>

                                <manager4 manager3="67" id="301”>Persons Name</manager4>

                                <manager4 manager3="67" id="302”>Persons Name</manager4>

                                <manager4 manager3="67" id="303”>Persons Name</manager4>

                                <manager4 manager3="67" id="304”>Persons Name</manager4>

                                <manager4 manager3="67" id="305”>Persons Name</manager4>

                                <manager4 manager3="68" id="306”>Persons Name</manager4>

                                <manager4 manager3="68" id="307”>Persons Name</manager4>

                                <manager4 manager3="68" id="308”>Persons Name</manager4>

                                <manager4 manager3="68" id="309”>Persons Name</manager4>

                                <manager4 manager3="68" id="310”>Persons Name</manager4>

                                <manager4 manager3="68" id="311”>Persons Name</manager4>

                                <manager4 manager3="68" id="312”>Persons Name</manager4>

                                <manager4 manager3="68" id="313”>Persons Name</manager4>

                                <manager4 manager3="68" id="314”>Persons Name</manager4>

                                <manager4 manager3="68" id="315”>Persons Name</manager4>

                                <manager4 manager3="68" id="316”>Persons Name</manager4>

                                <manager4 manager3="68" id="317”>Persons Name</manager4>

                                <manager4 manager3="68" id="318”>Persons Name</manager4>

                                <manager4 manager3="68" id="319”>Persons Name</manager4>

                                <manager4 manager3="68" id="320”>Persons Name</manager4>

                                <manager4 manager3="68" id="321”>Persons Name</manager4>

                                <manager4 manager3="71" id="322”>Persons Name</manager4>

                                <manager4 manager3="71" id="323”>Persons Name</manager4>

                                <manager4 manager3="71" id="324”>Persons Name</manager4>

                                <manager4 manager3="71" id="325”>Persons Name</manager4>

                                <manager4 manager3="71" id="326”>Persons Name</manager4>

                                <manager4 manager3="71" id="327”>Persons Name</manager4>

                                <manager4 manager3="71" id="328”>Persons Name</manager4>

                                <manager4 manager3="71" id="329”>Persons Name</manager4>

                                <manager4 manager3="71" id="330”>Persons Name</manager4>

                                <manager4 manager3="71" id="331”>Persons Name</manager4>

                                <manager4 manager3="71" id="332”>Persons Name</manager4>

                                <manager4 manager3="71" id="333”>Persons Name</manager4>

                                <manager4 manager3="71" id="334”>Persons Name</manager4>

                                <manager4 manager3="71" id="335”>Persons Name</manager4>

                                <manager4 manager3="71" id="336”>Persons Name</manager4>

                                <manager4 manager3="71" id="337”>Persons Name</manager4>

                                <manager4 manager3="72" id="338”>Persons Name</manager4>

                                <manager4 manager3="72" id="339”>Persons Name</manager4>

                                <manager4 manager3="72" id="340”>Persons Name</manager4>

                                <manager4 manager3="72" id="341”>Persons Name</manager4>

                                <manager4 manager3="72" id="342”>Persons Name</manager4>

                                <manager4 manager3="72" id="343”>Persons Name</manager4>

                                <manager4 manager3="72" id="344”>Persons Name</manager4>

                                <manager4 manager3="72" id="345”>Persons Name</manager4>

                                <manager4 manager3="72" id="346”>Persons Name</manager4>

                                <manager4 manager3="72" id="347”>Persons Name</manager4>

                                <manager4 manager3="73" id="348”>Persons Name</manager4>

                                <manager4 manager3="73" id="349”>Persons Name</manager4>

                                <manager4 manager3="73" id="350”>Persons Name</manager4>

                                <manager4 manager3="73" id="351”>Persons Name</manager4>

                                <manager4 manager3="73" id="352”>Persons Name</manager4>

                                <manager4 manager3="73" id="353”>Persons Name</manager4>

                                <manager4 manager3="73" id="354”>Persons Name</manager4>

                                <manager4 manager3="73" id="355”>Persons Name</manager4>

                                <manager4 manager3="73" id="356”>Persons Name</manager4>

                                <manager4 manager3="73" id="357”>Persons Name</manager4>

                                <manager4 manager3="73" id="358”>Persons Name</manager4>

                                <manager4 manager3="73" id="359”>Persons Name</manager4>

                                <manager4 manager3="73" id="360”>Persons Name</manager4>

                                <manager4 manager3="73" id="361”>Persons Name</manager4>

                                <manager4 manager3="74" id="362”>Persons Name</manager4>

                                <manager4 manager3="74" id="363”>Persons Name</manager4>

                                <manager4 manager3="74" id="364”>Persons Name</manager4>

                                <manager4 manager3="74" id="365”>Persons Name</manager4>

                                <manager4 manager3="74" id="366”>Persons Name</manager4>

                                <manager4 manager3="74" id="367”>Persons Name</manager4>

                                <manager4 manager3="74" id="368”>Persons Name</manager4>

                                <manager4 manager3="74" id="369”>Persons Name</manager4>

                                <manager4 manager3="74" id="370”>Persons Name</manager4>

                                <manager4 manager3="74" id="371”>Persons Name</manager4>

                                <manager4 manager3="74" id="372”>Persons Name</manager4>

                                <manager4 manager3="74" id="373”>Persons Name</manager4>

                                <manager4 manager3="74" id="374”>Persons Name</manager4>

                                <manager4 manager3="74" id="375”>Persons Name</manager4>

                                <manager4 manager3="74" id="376”>Persons Name</manager4>

                                <manager4 manager3="74" id="377”>Persons Name</manager4>

                                <manager4 manager3="74" id="378”>Persons Name</manager4>

                                <manager4 manager3="75" id="379”>Persons Name</manager4>

                                <manager4 manager3="75" id="380”>Persons Name</manager4>

                                <manager4 manager3="75" id="381”>Persons Name</manager4>

                                <manager4 manager3="75" id="382”>Persons Name</manager4>

                                <manager4 manager3="75" id="383”>Persons Name</manager4>

                                <manager4 manager3="75" id="384”>Persons Name</manager4>

                                <manager4 manager3="75" id="385”>Persons Name</manager4>

                                <manager4 manager3="75" id="386”>Persons Name</manager4>

                                <manager4 manager3="75" id="387”>Persons Name</manager4>

                                <manager4 manager3="75" id="388”>Persons Name</manager4>

                                <manager4 manager3="75" id="389”>Persons Name</manager4>

                </Manager_Lvl4>

                <Manager_Lvl5>

                                <manager5 manager4="62”>Persons Name</manager5>

                                <manager5 manager4="62”>Persons Name</manager5>

                                <manager5 manager4="62”>Persons Name</manager5>

                                <manager5 manager4="62”>Persons Name</manager5>

                                <manager5 manager4="62”>Persons Name</manager5>

                                <manager5 manager4="62”>Persons Name</manager5>

                                <manager5 manager4="62”>Persons Name</manager5>

                                <manager5 manager4="62”>Persons Name</manager5>

                                <manager5 manager4="62”>Persons Name</manager5>

                                <manager5 manager4="62”>Persons Name</manager5>

                                <manager5 manager4="62”>Persons Name</manager5>

                                <manager5 manager4="164”>Persons Name</manager5>

                                <manager5 manager4="164”>Persons Name</manager5>

                                <manager5 manager4="164”>Persons Name</manager5>

                                <manager5 manager4="164”>Persons Name</manager5>

                                <manager5 manager4="164”>Persons Name</manager5>

                </Manager_Lvl5>

</data>

 

And the qrules, dont know how to do that without admin rights, which i will probably never have.

Well, and since you are using an XML datasource, you pretty much would have to take the second option, basically copying only the correct data into another data source (so that you'd have your original data if the user changed selections). And there would probably be a way to do this with qRules CopyTable, since you could filter the command, only copy the data you need. If I get a chance later today or sometime tomorrow, I'll inject a form w/ the trial version of qRules and put together a sample, okay?

this being done with code, i have it pretty much figured out, except i cant figure out how to write a value to a repeating field.  I have a datasource that is a repeating field called level3source.  My level 3 dropdown box looks up the data in the repeating field.  For some reason it is not writing data into the field.  In the code below, this is where i am having issues (   writer.WriteElementString("level3Source", NamespaceManager.LookupNamespace("my"), manager3Navigator.Value);    ) .  I have the correct value  that i want to write in manager3Navigator.Value, but when i run that line, it doesnt put anything in there.

public void level2_Changed(object sender, XmlEventArgs e)

{

XPathNavigator parent = e.Site.SelectSingleNode("..");

// Remove existing values first

List<XPathNavigator> nodesToDelete = new List<XPathNavigator>();foreach (XPathNavigator level3SourceNode in parent.Select("my:level3Source", NamespaceManager))

{

// Cannot just call DeleteSelf on the navigator because it alters the iteration state.

// Instead, collect the navigators for future deletion.

nodesToDelete.Add(level3SourceNode.Clone());

}

// Now remove all the nodes.

foreach (XPathNavigator level3SourceNode in nodesToDelete)

{

level3SourceNode.DeleteSelf();

}

XPathNavigator mainNav = this.CreateNavigator(); string matchingManager_Lvl3XPath = String.Format("/data/Manager_Lvl3/manager3[@manager2 = '{0}']", e.Site.Value);

// For each matching manager, add it to the collection

foreach (XPathNavigator manager3Navigator in this.DataSources["Roster"].CreateNavigator().Select(matchingManager_Lvl3XPath))

{

using (XmlWriter writer = parent.AppendChild())

{

writer.WriteElementString("level3Source", NamespaceManager.LookupNamespace("my"), manager3Navigator.Value);

string fieldValue = mainNav.SelectSingleNode("/my:myFields/my:group1/my:group2/my:level3source", NamespaceManager).Value;

}

}

}

So i think i got the first level.  But my next level doesnt work.  instead of the id number, i get the actual name of the person.

I'm going to have to guess what you mean here - is the drop down set up correctly on the control you are selecting with? That is, is the value set to ID and the display set to name? If I'm misunderstanding your issue, could you provide more information?

I am so lost now.  I need a different way to do these cascading list boxes.  Nothing I try works.  I am fried.