InfoPath Dev

Here is the link. No code required which is allowing you to keep form trust level as domain. http://blog.ianchivers.com/wordpress/?p=37  

THere is a good article how to use that method in InfoPath on the web. Sorry, I don't have time to find it right now. If you wont be able find it in couple hours I'll try to find some time to do that for you.

[quote user="AyaBabe"] I thought user roles weren't supported by InfoPath Forms Services............................. [/quote]   That's correct they are not supported. But because you have access to the MOSS webservices you could use usergroup.asmx to determine if user is a member of a group.Although connecting that ...

I believe that operation is called pivoting. And probably Infopath isn't a good tool to do that. I suggest you should to task your SQL admin guy to create the view you could consume in InfoPath. Another way would be to use analytic tools like SQL Analysis Services where the data already is aggregated in desired fashion.

[quote user="Patrick Halstead"] Too bad that calling MOSS webservice requires full trust since that will complicate deployment of browser based forms slightly. [/quote]  Oddly enough my form capable to call MOSS websevice having only domain trust level. Well... probably I have different version of MOSS server :)

It does work with browser enabled forms. But Control Selector isn't a good control to trigger the siquence of events. In my case I moved all rules from Control Selector to the submit button.  BTW where you noticed I can't publish a browser-enabled version?

Well, it would be nice to pull data right from AD. But pity enough there is no such thing as AD in InfoPath context. So poor InfoPath developers have no choice but utilize webservices wich usally return requested data as repeating XML structure (aka repeating table).  Of course if you dont have problems to code in C# there is such nice ...

[quote user="riehmc"] If I have a gpContactSelector with the 3 strings (DisplayName, AccountID, AccountType), can I add a string here called Email?  [/quote] Yes you can. But Contact Selector wont populate it for you unless you going to use the workaround at the end of the article to populate repeating ...

[quote user="riehmc"] I followed your blog instructions to the letter except for this part, I can not find what you are referring to -- "In data source pane choose main data source. Double click at replyToControl group".  Where is the replyToControl?   [/quote] It's the name I gave to the Contact Selector ...

[quote user="riehmc"]  But if I create another field within the contact selector such as Division or Title, it returns nothing.  I not sure if there is something I may be missing or if I need to call the value something else for it to see what data to pull from AD. [/quote]  Here is example how to retrieve email. You ...