Ranking Tool using InfoPath (No-Code Solution)

Note: This solution is built using InfoPath 2007 non browser based form.

Steps to create this solution are provided below:

1.    Create an XML file to store the rank values, Ranks.xml

2.    Design a non browser based InfoPath 2007 Form

3.    Design the layout and add fields as required

4.    Add a “Receive Data” connection to the Ranks.xml file

5.    Add Drop-Down List boxes for the field InfyRank, TCSRank, WiproRank, HCLRank, and CTSRank

6.    Now add the values possible for the drop down lists as given below

7.    Repeat the same steps accordingly for all the drop down list boxes

8.    And, that is it.

Repeating Table - Sub Totals

1. Drag and drop the repeating group on the InfoPath Form

2. Create a text field which will hold the unique Column A values, Choice A, in the main data source
3. Add a Drop Down List for the field Choice A

4. Set the value the just created drop down list to hold unique values of Column A

5. Create a numeric field which will hold total of Column N for the chosen Column A, in the main data source, as Total N

6. Now set the value of the field Total N

7. This is it. Now we can test.