InfoPath Dev

I need to sort repeating table after it is read in from an Access database and before it is displayed. I need to sort on two columns Budget Element and Date. Table looks like below. What  is the best way to do this.

Control Account   Budget Element   Date  Hrs  Dols

Hi,

Check out the "Asset Tracking" sample that came with InfoPath.   It has code that uses a drop down list that sorts the assets, and a "Sort" button with the code in the onClick event.

Stephanie

Yes, the Asset Tracking example from InfoPath 2003 does have code to do this and you can leverage that in your solution.

Unfortuantely the InfoPath 2007 Asset Tracking solution does not have this because the design point for the InfoPath 2007 samples was to not use any code. Sorting items in InfoPath currently requires code.

You can get a copy of the IP2003 Asset Tracking solution from the Microsoft web site if you only have IP2007. It will work in IP2007 just fine. It is available here: http://office.microsoft.com/en-us/templates/TC010785081033.aspx?pid=CT101481361033