Calculating and Displaying "top 3" from a SharePoint Library Data Connection

ToastyMcCheese — Thu, 19 May 2011 23:00:47 GMT

Hi there, I wanted to start out by saying this website is absolutely great. I just started working with InfoPath a couple of weeks ago and thanks to the help I've found here I've been able to fly through some pretty advanced projects with it. Currently though I've found myself stuck, what I am trying to do is display a table at the top of my form featuring sales figures from the agents submitting the forms. The trick is that more then 100+ people will be utilizing the form so we need to a) find a way to calculate total sale numbers for the agents and then b) display just the top 3 agents and their sales. My main problem is that whenever I try to call the field from the secondary data connection via C# it reports it as blank and doesn't let me analyze it or any of the other pieces of information within that field. I'm just looking for a place to kick off from, a way of analyzing and handling all the data from the SharePoint. Any help you all could provide would be amazing, thanks so much in advance!At this point with the project we are using C# and have several other functions utilized in it so if possible I would like to stay with C# though if someone has a solution from another programming method I wouldn't mind recoding what we have done so far.

SharePoint Integration

Calculating and Displaying "top 3" from a SharePoint Library Data Connection