InfoPath Dev

Well, what kind of report form? You can already pull all of your data from InfoPath into the library by promoting the properties.  Then, you can do all sorts of things with that data in SharePoint, such as grouping, filtering, sorting, and doing totals.  Also, you can have a datasheet view that acts as a spreadsheet that you can then ...

There are many different causes for the data access error when using the UserProfile web service, so we would need to narrow down the variables.  The big question is what happens when you just log in to your computer on the domain with a normal user ID and then try to open the form?  Does it work?  If not, then we can start ...

Please check it twice. I noticed that my initial post had wrong quotes and it's posible to copy/paste them into InfoPath. So if you hadn't fix them intentionaly they should be wrong ones.

That is simply the rich text editor on this forum.  I checked the formula in my InfoPath form and they are ";"

 

Take a look on quotes you are using ”;”. They are wrong ones.  Use ";"

OK, that worked...except that it is a browser-based form and I get the following error when publishing:The following expression could not be parsed because of a syntax error or because it uses an unidentified namespace prefix or unsupported function:../my:HlinkToEmail,”;”,../my:To/my:Person[number(/my:myFields/my:fCounter)]/my:AccountId 

Thanks for the information, but this does not account for other nuances of the default view in SharePoint.  The view in SharePoint also does some filtering that does not seem to be reproduced in the form service on MOSS.  Personally I think its a bug or a gross oversight by Microsoft that the SharePoint dataconnection does not properly ...

You nailed it on the head.  I know there's a way to retrieve the Sharepoint ID for the file and use a rule to set the value of the field equal to that plus 1.  I'm guessing it's max(@ID) + 1, however I haven't been able to get it to work quite yet.

First I would try to check if iteration is happening at all. For that you need temporary replace XPath expression in 3rd action to  concat(../my:HlinkToEmail,”;”,../my:To/my:Person[number(/my:myFields/my:fCounter)]/my:AccountId) so if iteration is working the result should be concatenation of login names.  Also make sure that 2 ...